CREATE TABLE list (classroom VARCHAR2, firstname VARCHAR2, lastname VARCHAR2)
CREATE TABLE teachers (firstname VARCHAR2, lastname VARCHAR2, classroom VARCHAR2)

Find the first and last name of all the teachers that teach EVELINA BROMLEY.
SELECT T2.firstname, T2.lastname FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T1.firstname = "EVELINA" AND T1.lastname = "BROMLEY"
SELECT "T2"."firstname", "T2"."lastname" FROM "list" "T1" JOIN "teachers" "T2" ON "T1"."classroom" = "T2"."classroom" WHERE "BROMLEY" = "T1"."lastname" AND "EVELINA" = "T1"."firstname"