For each grade 0 classroom, report the total number of students.
CREATE TABLE list (classroom VARCHAR, grade VARCHAR)
SELECT classroom, COUNT(*) FROM list WHERE grade = "0" GROUP BY classroom
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE list (classroom VARCHAR, grade VARCHAR) Question: For each grade 0 classroom, report the total number of students. [/INST] SELECT classroom, COUNT(*) FROM list WHERE grade = "0" GROUP BY classroom </s>