CREATE TABLE Allergy_type (Allergy VARCHAR2, AllergyType VARCHAR2)
CREATE TABLE Student (StuID VARCHAR2, Fname VARCHAR2)
CREATE TABLE Has_allergy (Allergy VARCHAR2, StuID VARCHAR2)

What are the allergies and their types that the student with first name Lisa has? And order the result by name of allergies.
SELECT T1.Allergy, T1.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" ORDER BY T1.Allergy
SELECT "T1"."Allergy", "T1"."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" ORDER BY "T1"."Allergy"