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