150. GROUP BY with Aggregates

1SELECT course,
2  COUNT(*) AS total,
3  AVG(marks) AS avg_marks,
4  MAX(marks) AS top_marks
5FROM students
6GROUP BY course;