CREATE TABLE teachers (classroom VARCHAR)
CREATE TABLE list (classroom VARCHAR, firstname VARCHAR, lastname VARCHAR)

How many teachers does the student named CHRISSY NABOZNY have?
SELECT COUNT(*) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T1.firstname = "CHRISSY" AND T1.lastname = "NABOZNY"
SELECT COUNT(*) FROM "list" AS "T1" JOIN "teachers" AS "T2" ON "T1"."classroom" = "T2"."classroom" WHERE "CHRISSY" = "T1"."firstname" AND "NABOZNY" = "T1"."lastname"