human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
How many students does KAWA GORDON teaches?
assistant
SELECT COUNT( * ) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T2.firstname = 'KAWA' AND T2.lastname = 'GORDON';
human
How many students does MIN MACROSTIE teaches?
assistant
SELECT COUNT( * ) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T2.firstname LIKE '%MIN%' AND T2.lastname LIKE '%MACROSTIE%';
human
What are the first and last names of the teachers that teach STORMY CHRISTENSEN?
assistant
SELECT T2.firstname , T2.lastname FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T1.firstname LIKE "%STORMY%" AND T1.lastname LIKE "%CHRISTENSEN%" ;