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

Show all allergy types and the number of allergies in each type Plot them as bar chart, and rank bars in ascending order.
SELECT AllergyType, COUNT(*) FROM Allergy_Type GROUP BY AllergyType ORDER BY AllergyType
SELECT "AllergyType", COUNT(*) FROM "Allergy_Type" GROUP BY "AllergyType" ORDER BY "AllergyType" NULLS FIRST