Who have allergy to soy?
select * from has_allergy where allergy = "Soy"
Who have not?
select * from student where stuid not in (select stuid from has_allergy where allergy = "Soy")
List their first name and major.
select fname, major from student where stuid not in (select stuid from has_allergy where allergy = "Soy")