CREATE TABLE list (lastname TEXT, firstname TEXT, grade DECIMAL, classroom DECIMAL)
CREATE TABLE teachers (lastname TEXT, firstname TEXT, classroom DECIMAL)

Find the last names of students studying in room 111.
SELECT lastname FROM list WHERE classroom = 111
SELECT "lastname" FROM "list" WHERE "classroom" = 111