For each grade, report the grade, the number of classrooms in which it is taught and the total number of students in the grade.
CREATE TABLE list (grade VARCHAR, classroom VARCHAR)
SELECT grade, COUNT(DISTINCT classroom), COUNT(*) FROM list GROUP BY grade
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE list (grade VARCHAR, classroom VARCHAR) Question: For each grade, report the grade, the number of classrooms in which it is taught and the total number of students in the grade. [/INST] SELECT grade, COUNT(DISTINCT classroom), COUNT(*) FROM list GROUP BY grade </s>