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

What are the last names of students in room 111?
SELECT lastname FROM list WHERE classroom = 111
SELECT "lastname" FROM "list" WHERE "classroom" = 111