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

Find the classrooms in which grade 4 is studying.
SELECT DISTINCT classroom FROM list WHERE grade = 4
SELECT DISTINCT "classroom" FROM "list" WHERE "grade" = 4