CREATE TABLE list (grade VARCHAR2, classroom VARCHAR2)

For each grade, report the grade, the number of classrooms in which it is taught and the total number of students in the grade.
SELECT grade, COUNT(DISTINCT classroom), COUNT(*) FROM list GROUP BY grade
SELECT "grade", COUNT(DISTINCT "classroom"), COUNT(*) FROM "list" GROUP BY "grade"