Who has at least two allergies?
select * from has_allergy group by stuid having count(*) >= 2
What are their ids?
select stuid from has_allergy group by stuid having count(*) >= 2