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

Which are the first and last names of the students taught by MARROTTE KIRK?
SELECT T1.firstname, T1.lastname FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T2.firstname = "MARROTTE" AND T2.lastname = "KIRK"
SELECT "T1"."firstname", "T1"."lastname" FROM "list" "T1" JOIN "teachers" "T2" ON "KIRK" = "T2"."lastname" AND "MARROTTE" = "T2"."firstname" AND "T1"."classroom" = "T2"."classroom"