How many classrooms are there?
select distinct classroom from list
Show me the classrooms that any fourth-grade is in.
select distinct classroom from list where grade = '4'
How many students are in each of those classrooms?
select classroom, count(*) from list where grade = "4" group by classroom