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

What are the first names of students in room 108?
SELECT firstname FROM list WHERE classroom = 108
SELECT "firstname" FROM "list" WHERE "classroom" = 108