Database: student_1
Question: For each fourth-grade classroom, show the classroom number and the total number of students using it.
SQL:
SELECT classroom ,  count(*) FROM list WHERE grade  =  "4" GROUP BY classroom