For each grade 0 classroom, report the total number of students.
CREATE TABLE list (classroom VARCHAR, grade VARCHAR)
SELECT classroom, COUNT(*) FROM list WHERE grade = "0" GROUP BY classroom
### Context: CREATE TABLE list (classroom VARCHAR, grade VARCHAR) ### Question: For each grade 0 classroom, report the total number of students. ### Answer: SELECT classroom, COUNT(*) FROM list WHERE grade = "0" GROUP BY classroom