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

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