CREATE TABLE teachers (LastName TEXT, FirstName TEXT, Classroom INT)
CREATE TABLE list (LastName TEXT, FirstName TEXT, Grade INT, Classroom INT)

Return a scatter on how many students does one classroom have?
SELECT COUNT(*), Classroom FROM list GROUP BY Classroom
SELECT COUNT(*), "Classroom" FROM "list" GROUP BY "Classroom"