SELECT count(*) ,  classroom FROM list GROUP BY classroom
How many students does one classroom have?
SELECT count ( * ) , classroom FROM list GROUP BY classroom
select count ( * ) , classroom from list group by classroom
How many students does one classroom have ?