Using the relations already provided to you namely , student, module, marks and write the following stored procedure as input the module code, the weight for coursework in sql. It will display the grades for students for a specific module based on total marks. Gradings are as follows:

modules - maths, programming, system design, database

Total Marks >80 = A+

Total marks between 71 and 80= A

Total marks between 61 and 70= B

Total marks between 51 and 60 = C

Total marks less than 50 = F

1.Using Sql display Minimum total marks, average total marks, and maximum total marks for each module

2.Using Sql display the ID of all students who have failed and the modules they have failed.