SELECT classroom ,  count(*) FROM list WHERE grade  =  "0" GROUP BY classroom
For each grade 0 classroom, return the classroom number and the count of students.
SELECT classroom , count ( * ) FROM list WHERE grade = `` 0 '' GROUP BY classroom
select classroom , count ( * ) from list where grade = value group by classroom
For each grade 0 classroom , return the classroom number and the count of students .