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

Find the last names of teachers teaching in classroom 109.
SELECT lastname FROM teachers WHERE classroom = 109
SELECT "lastname" FROM "teachers" WHERE "classroom" = 109