Database: student_1
Question: How many students does one classroom have?
SQL:
SELECT count(*) ,  classroom FROM list GROUP BY classroom