Which allergy has most number of students affected?
SELECT Allergy FROM Has_allergy GROUP BY Allergy ORDER BY count(*) DESC LIMIT 1
allergy with the most number of students affected refers to MAX(COUNT(student_id));