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

What is the number of each allergie that the student with first name Lisa has? Draw a bar chart.
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
SELECT "T1"."Allergy", COUNT("T1"."Allergy") 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 "T1"."Allergy"