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

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" 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