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

Report the number of students in each classroom.
SELECT classroom, COUNT(*) FROM list GROUP BY classroom
SELECT "classroom", COUNT(*) FROM "list" GROUP BY "classroom"