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