SELECT Allergy FROM Has_allergy GROUP BY Allergy ORDER BY count(*) DESC LIMIT 1
Which allergy has most number of students affected?
SELECT Allergy FROM Has_allergy GROUP BY Allergy ORDER BY count ( * ) DESC LIMIT 1
select allergy from has_allergy group by allergy order by count ( * ) desc limit value
Which allergy has most number of students affected ?