CREATE TABLE list (LastName CLOB, FirstName CLOB, Grade NUMBER, Classroom NUMBER)
CREATE TABLE teachers (LastName CLOB, FirstName CLOB, Classroom NUMBER)

Plot a scatter chart, count(*) by classroom.
SELECT COUNT(*), Classroom FROM list GROUP BY Classroom
SELECT COUNT(*), "Classroom" FROM "list" GROUP BY "Classroom"