Write a query to display the names of all courses followed by these 4 data items:
-
maximum marks scored by students in the course
-
minimum marks scored by students in the course
-
sum of all marks scored by students in the course
-
average of marks scored by students in the course
Set the headers for the 5 columns as courseName, maximumMarks, minimumMarks, sumOfMarks and averageMarks respectively.