Can you give me the allergies that the student with the first name Lisa has
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"
Can i have the list of foods that Lisa is 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" and t1.allergytype = "food"