148. GROUP BY with COUNT

1SELECT course, COUNT(*) AS student_count
2FROM students
3GROUP BY course;