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

Which classroom has the most students?
SELECT classroom FROM list GROUP BY classroom ORDER BY COUNT(*) DESC LIMIT 1
SELECT "classroom" FROM "list" GROUP BY "classroom" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1