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

Scatter plot to show classroom on x axis and the total number on y axis.
SELECT Classroom, COUNT(*) FROM list GROUP BY Classroom
SELECT "Classroom", COUNT(*) FROM "list" GROUP BY "Classroom"