JOINS - Grouping
43.1 - Ex 2
Exercise

JOINs with GROUP BY - 2

Write a query to display the names of all courses followed by these 4 data items:

  1. maximum marks scored by students in the course

  2. minimum marks scored by students in the course

  3. sum of all marks scored by students in the course

  4. average of marks scored by students in the course

Set the headers for the 5 columns as courseName, maximumMarks, minimumMarks, sumOfMarks and averageMarks respectively.