CREATE TABLE teachers (lastname TEXT, firstname TEXT, classroom DECIMAL)
CREATE TABLE list (lastname TEXT, firstname TEXT, grade DECIMAL, classroom DECIMAL)

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" AS "T1" JOIN "teachers" AS "T2" ON "GORDON" = "T2"."lastname" AND "KAWA" = "T2"."firstname" AND "T1"."classroom" = "T2"."classroom"