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

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" 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" ORDER BY "T1"."allergy" NULLS FIRST