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

How many students does LORIA ONDERSMA teaches?
SELECT COUNT(*) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T2.firstname = "LORIA" AND T2.lastname = "ONDERSMA"
SELECT COUNT(*) FROM "list" "T1" JOIN "teachers" "T2" ON "LORIA" = "T2"."firstname" AND "ONDERSMA" = "T2"."lastname" AND "T1"."classroom" = "T2"."classroom"