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

How many students does one classroom have?
SELECT COUNT(*), classroom FROM list GROUP BY classroom
SELECT COUNT(*), "classroom" FROM "list" GROUP BY "classroom"