SELECT classroom ,  count(*) FROM list GROUP BY classroom
Report the number of students in each classroom.
SELECT classroom , count ( * ) FROM list GROUP BY classroom
select classroom , count ( * ) from list group by classroom
Report the number of students in each classroom .