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

Find the number of students in one classroom. Plot them as scatter chart.
SELECT COUNT(*), Classroom FROM list GROUP BY Classroom
SELECT COUNT(*), "Classroom" FROM "list" GROUP BY "Classroom"