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

For each classroom, show the classroom number and find how many students are using it. Plot them as scatter chart.
SELECT Classroom, COUNT(*) FROM list GROUP BY Classroom
SELECT "Classroom", COUNT(*) FROM "list" GROUP BY "Classroom"