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)

What is the number of each allergie the girl named Lisa has? Plot them as bar chart, and sort by the total number in asc.
SELECT T1.Allergy, COUNT(T1.Allergy) FROM Allergy_Type AS T1 JOIN Has_Allergy AS T2 ON T1.Allergy = T2.Allergy JOIN Student AS T3 ON T3.StuID = T2.StuID WHERE T3.Fname = "Lisa" GROUP BY T1.Allergy ORDER BY T1.Allergy
SELECT "T1"."Allergy", COUNT("T1"."Allergy") FROM "Allergy_Type" AS "T1" JOIN "Has_Allergy" AS "T2" ON "T1"."Allergy" = "T2"."Allergy" JOIN "Student" AS "T3" ON "Lisa" = "T3"."Fname" AND "T2"."StuID" = "T3"."StuID" GROUP BY "T1"."Allergy" ORDER BY "T1"."Allergy" NULLS FIRST