CREATE TABLE Has_Allergy (StuID INT, Allergy VARCHAR)
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)

Show the number of each allergie type in a bar chart, and display by the X in desc.
SELECT AllergyType, COUNT(AllergyType) FROM Allergy_Type GROUP BY AllergyType ORDER BY AllergyType DESC
SELECT "AllergyType", COUNT("AllergyType") FROM "Allergy_Type" GROUP BY "AllergyType" ORDER BY "AllergyType" DESC NULLS LAST