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

For each grade 0 classroom, report the total number of students. Visualize by scatter chart.
SELECT Classroom, COUNT(*) FROM list WHERE Grade = "0" GROUP BY Classroom
SELECT "Classroom", COUNT(*) FROM "list" WHERE "0" = "Grade" GROUP BY "Classroom"