SELECT classroom FROM list GROUP BY classroom ORDER BY count(*) DESC LIMIT 1
Which classroom has the most students?
SELECT classroom FROM list GROUP BY classroom ORDER BY count ( * ) DESC LIMIT 1
select classroom from list group by classroom order by count ( * ) desc limit value
Which classroom has the most students ?