Database: student_1
Question: Report the number of students in each classroom.
SQL:
SELECT classroom ,  count(*) FROM list GROUP BY classroom