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

Find the number of students taught by the teacher KAWA GORDON.
SELECT COUNT(*) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T2.firstname = "KAWA" AND T2.lastname = "GORDON"
SELECT COUNT(*) FROM "list" "T1" JOIN "teachers" "T2" ON "GORDON" = "T2"."lastname" AND "KAWA" = "T2"."firstname" AND "T1"."classroom" = "T2"."classroom"