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