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

What is the number of each allergie type? Return a bar chart, and could you order by the x-axis from low to high?
SELECT AllergyType, COUNT(AllergyType) FROM Allergy_Type GROUP BY AllergyType ORDER BY AllergyType
SELECT "AllergyType", COUNT("AllergyType") FROM "Allergy_Type" GROUP BY "AllergyType" ORDER BY "AllergyType"