SELECT classroom ,  count(DISTINCT grade) FROM list GROUP BY classroom
For each classroom, show the classroom number and count the number of distinct grades that use the room.
SELECT classroom , count ( DISTINCT grade ) FROM list GROUP BY classroom
select classroom , count ( distinct grade ) from list group by classroom
For each classroom , show the classroom number and count the number of distinct grades that use the room .