Consider the following tables :
Student(stuID, surname, otherNames, age, address) Module(moduleID, moduleName, prerequisite) Registration(stuID,moduleID,dateRegistered) Marks(stuID, moduleID, academicYear ,courseworkMarks, examsMarks,grade)
Write SQL statement to retrieve details of all the students who have registered for the module 'CSE1016Y'. The details to be retrieved are the student id, name of the student, the module code, the date he/she registered and the coursework and examination marks for all the modules he/she registered for.
Write SQL statement to retrieve the minimum total marks, maximum total marks and average total marks scored for each module. The year as well as the code and name of the module should also be displayed. The results should be ordered by year and module code.