CREATE TABLE teachers (lastname CLOB, firstname CLOB, classroom NUMBER)
CREATE TABLE list (lastname CLOB, firstname CLOB, grade NUMBER, classroom NUMBER)

For each classroom, show the classroom number and count the number of distinct grades that use the room.
SELECT classroom, COUNT(DISTINCT grade) FROM list GROUP BY classroom
SELECT "classroom", COUNT(DISTINCT "grade") FROM "list" GROUP BY "classroom"