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

Which teachers teach in classroom 110? Give me their first names.
SELECT firstname FROM teachers WHERE classroom = 110
SELECT "firstname" FROM "teachers" WHERE "classroom" = 110