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)

How many students have each different allergy Show bar chart, and I want to order in ascending by the total number.
SELECT Allergy, COUNT(*) FROM Has_Allergy GROUP BY Allergy ORDER BY COUNT(*)
SELECT "Allergy", COUNT(*) FROM "Has_Allergy" GROUP BY "Allergy" ORDER BY COUNT(*) NULLS FIRST