SELECT StuID FROM Has_allergy GROUP BY StuID HAVING count(*)  >=  2
Show all student IDs who have at least two allergies.
SELECT StuID FROM Has_allergy GROUP BY StuID HAVING count ( * ) > = 2
select stuid from has_allergy group by stuid having count ( * ) > = value
Show all student IDs who have at least two allergies .