Database: student_1
Question: For each classroom, show the classroom number and find how many students are using it.
SQL:
SELECT classroom ,  count(*) FROM list GROUP BY classroom