Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: What are the allergies and their types that the student with first name Lisa has? And order the result by name of allergies. | allergy_type : allergy , allergytype | has_allergy : stuid , allergy | student : stuid , lname , fname , age , sex , major , advisor , city_code | has_allergy.allergy = allergy_type.allergy | has_allergy.stuid = student.stuid | 

### Response:

select _ from _ where _ order by _ asc | select allergy_type.allergy , allergy_type.allergytype from allergy_type join has_allergy on allergy_type.allergy = has_allergy.allergy join student on student.stuid = has_allergy.stuid where student.fname = 'Lisa' order by allergy_type.allergy asc