CREATE TABLE list (classroom VARCHAR(255))
Find the number of students in one classroom.
    
SQL: SELECT COUNT(*), classroom FROM list GROUP BY classroom