For each classroom, report the classroom number and the number of grades using it.
CREATE TABLE list (classroom VARCHAR, grade VARCHAR)
SELECT classroom, COUNT(DISTINCT grade) FROM list GROUP BY classroom
### Context: CREATE TABLE list (classroom VARCHAR, grade VARCHAR) ### Question: For each classroom, report the classroom number and the number of grades using it. ### Answer: SELECT classroom, COUNT(DISTINCT grade) FROM list GROUP BY classroom