How many teachers does the student named CHRISSY NABOZNY have?
create table teachers (classroom varchar, PRIMARY KEY (classroom)); create table list (classroom varchar, firstname varchar, lastname varchar, PRIMARY KEY (classroom))
select count(*) from list as t1 join teachers as t2 on t1.classroom = t2.classroom where t1.firstname = "chrissy" and t1.lastname = "nabozny"