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

Find all students taught by MARROTTE KIRK. Output first and last names of students.
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"