CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE has_allergy (stuid NUMBER, allergy CLOB)
CREATE TABLE allergy_type (allergy CLOB, allergytype CLOB)

What are the allergies the girl named Lisa has? And what are the types of them? Order the result by allergy names.
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"