CREATE TABLE list (LastName CLOB, FirstName CLOB, Grade NUMBER, Classroom NUMBER)
CREATE TABLE teachers (LastName CLOB, FirstName CLOB, Classroom NUMBER)

Scatter. how many students does one classroom have?
SELECT COUNT(*), Classroom FROM list GROUP BY Classroom
SELECT COUNT(*), "Classroom" FROM "list" GROUP BY "Classroom"