human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
How many teachers are there in record?
assistant
SELECT COUNT( * ) FROM teachers;
human
What classrooms is CHRISSY NABOZNY in?
assistant
SELECT classroom FROM list WHERE firstname = 'CHRISSY' AND lastname = 'NABOZNY';
human
How many are they?
assistant
SELECT COUNT( * ) FROM list AS T1 JOIN teachers AS T2 ON T1.classroom = T2.classroom WHERE T1.firstname = "CHRISSY" AND T1.lastname = "NABOZNY" ;