How many students does KAWA GORDON teaches?
select count ( * ) from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t2.firstname = "KAWA" and t2.lastname = "GORDON"
How many students does MIN MACROSTIE teaches?
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%"
What are the first and last names of the teachers that teach STORMY CHRISTENSEN?
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%"