CREATE TABLE teachers (lastname TEXT, firstname TEXT, classroom DECIMAL)
CREATE TABLE list (lastname TEXT, firstname TEXT, grade DECIMAL, classroom DECIMAL)

For each fourth-grade classroom, show the classroom number and the total number of students using it.
SELECT classroom, COUNT(*) FROM list WHERE grade = "4" GROUP BY classroom
SELECT "classroom", COUNT(*) FROM "list" WHERE "4" = "grade" GROUP BY "classroom"