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)
[SQL] SELECT grade, COUNT(DISTINCT classroom), COUNT(*) FROM list GROUP BY grade [/SQL]