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

How many students does one classroom have. Show the correlation.
SELECT COUNT(*), Classroom FROM list GROUP BY Classroom
SELECT COUNT(*), "Classroom" FROM "list" GROUP BY "Classroom"