CREATE TABLE teachers (lastname CLOB, firstname CLOB, classroom NUMBER)
CREATE TABLE list (lastname CLOB, firstname CLOB, grade NUMBER, classroom NUMBER)

For each grade 0 classroom, report the total number of students.
SELECT classroom, COUNT(*) FROM list WHERE grade = "0" GROUP BY classroom
SELECT "classroom", COUNT(*) FROM "list" WHERE "0" = "grade" GROUP BY "classroom"