human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the name of all teachers in record.
assistant
SELECT firstname , lastname FROM teachers;
human
Which classrooms does MARROTTE KIRK teach in?
assistant
SELECT classroom FROM teachers WHERE firstname = 'MARROTTE' AND lastname = 'KIRK';
human
Show me the name of students who are in those classrooms.
assistant
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" ;