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

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