SELECT classroom ,  count(*) FROM list WHERE grade  =  "4" GROUP BY classroom
For each fourth-grade classroom, show the classroom number and the total number of students using it.
SELECT classroom , count ( * ) FROM list WHERE grade = `` 4 '' GROUP BY classroom
select classroom , count ( * ) from list where grade = value group by classroom
For each fourth-grade classroom , show the classroom number and the total number of students using it .