-- Classes with more than 10 students SELECT student_class, COUNT(*) FROM students GROUP BY student_class HAVING count(*) > 10;