CREATE TABLE list (classroom VARCHAR, grade VARCHAR)

Report the total number of students for each fourth-grade classroom.
SELECT classroom, COUNT(*) FROM list WHERE grade = "4" GROUP BY classroom
SELECT "classroom", COUNT(*) FROM "list" WHERE "4" = "grade" GROUP BY "classroom"