CREATE TABLE Has_allergy (StuID VARCHAR2)

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(*) >= 2