SELECT classroom ,  count(*) FROM list GROUP BY classroom
For each classroom, show the classroom number and find how many students are using it.
SELECT classroom , count ( * ) FROM list GROUP BY classroom
select classroom , count ( * ) from list group by classroom
For each classroom , show the classroom number and find how many students are using it .