CREATE TABLE teachers (lastname TEXT, firstname TEXT, classroom DECIMAL)
CREATE TABLE list (lastname TEXT, firstname TEXT, grade DECIMAL, classroom DECIMAL)

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