CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Allergy_Type (Allergy VARCHAR, AllergyType VARCHAR)
CREATE TABLE Has_Allergy (StuID INT, Allergy VARCHAR)

Return a bar chart on how many students have each different allergy?
SELECT Allergy, COUNT(*) FROM Has_Allergy GROUP BY Allergy
SELECT "Allergy", COUNT(*) FROM "Has_Allergy" GROUP BY "Allergy"