SELECT fname ,  major FROM Student WHERE StuID NOT IN (SELECT StuID FROM Has_allergy WHERE Allergy  =  "Soy")
What are the first name and major of the students who are able to consume soy?
SELECT fname , major FROM Student WHERE StuID NOT IN ( SELECT StuID FROM Has_allergy WHERE Allergy = `` Soy '' )
select fname , major from student where stuid not in ( select stuid from has_allergy where allergy = value )
What are the first name and major of the students who are able to consume soy ?