Can you get me the first names of students that have a milk allergy?
select distinct t1.fname from student as t1 join has_allergy as t2 on t1.stuid = t2.stuid where t2.allergy = "Milk"
Yes. Can you please provide both simultaneously?
select distinct t1.city_code, t1.fname from student as t1 join has_allergy as t2 on t1.stuid = t2.stuid where t2.allergy = "Milk"