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