Most number of students affected by which allergy?
select allergy from has_allergy group by allergy order by count ( * ) desc limit 1
Which allergy affects student ID 1001
select allergy from has_allergy where stuid = 1001
Which allergy affects student ID 1002
select allergy from has_allergy where stuid = 1002