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

What is the number of each allergie type that the student with first name Lisa has? Visualize by bar chart, display bar in asc order.
SELECT AllergyType, COUNT(AllergyType) 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 AllergyType ORDER BY AllergyType
SELECT "AllergyType", COUNT("AllergyType") FROM "Allergy_Type" "T1" JOIN "Has_Allergy" "T2" ON "T1"."Allergy" = "T2"."Allergy" JOIN "Student" "T3" ON "Lisa" = "T3"."Fname" AND "T2"."StuID" = "T3"."StuID" GROUP BY "AllergyType" ORDER BY "AllergyType"