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

List the first names of all the students in room 107.
SELECT DISTINCT firstname FROM list WHERE classroom = 107
SELECT DISTINCT "firstname" FROM "list" WHERE "classroom" = 107