What is the girl with first name Lisa allergic to?
select 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"
What type is each 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 t3.stuid = t2.stuid where t3.fname = "Lisa"
Order them by the 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