Skip
Arish's avatar

149. Practice - GROUP BY COUNT

Exercise: Count by Grade

Count students in each grade.

Solution

sql
1SELECT grade, COUNT(*) AS count
2FROM students
3GROUP BY grade;