human
Schema:
list (LastName, FirstName, Grade, Classroom)
teachers (LastName, FirstName, Classroom)
Please answer with SQL.
assistant
Sure, I understand.
human
How many classrooms are there?
assistant
SELECT DISTINCT classroom FROM list;
human
Show me the classrooms that any zero grade is in.
assistant
SELECT distinct classroom FROM list WHERE grade = '0';
human
How many students are in each of those classrooms?
assistant
SELECT classroom , COUNT( * ) FROM list WHERE grade = "0" GROUP BY classroom ;