Report the number of students in each classroom.
CREATE TABLE list (classroom VARCHAR)
SELECT classroom, COUNT(*) FROM list GROUP BY classroom
### Context: CREATE TABLE list (classroom VARCHAR) ### Question: Report the number of students in each classroom. ### Answer: SELECT classroom, COUNT(*) FROM list GROUP BY classroom