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