How many classrooms are there?
select distinct classroom from list
How many students does each of them have?
select classroom, count(*) from list group by classroom
Give me the classroom with the most of them.
select classroom from list group by classroom order by count(*) desc limit 1