-- Database schema
| Allergy_Type : Allergy [ TEXT ] primary_key , AllergyType [ TEXT ] | Has_Allergy : StuID [ INT ] Has_Allergy.StuID = Student.StuID , Allergy [ TEXT ] Has_Allergy.Allergy = Allergy_Type.Allergy | Student : StuID [ INT ] primary_key , LName [ TEXT ] , Fname [ TEXT ] , Age [ INT ] , Sex [ TEXT ] , Major [ INT ] , Advisor [ INT ] , city_code [ 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;