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

Which classrooms are used by grade 4?
SELECT DISTINCT classroom FROM list WHERE grade = 4
SELECT DISTINCT "classroom" FROM "list" WHERE "grade" = 4