Database: allergy_1
Question: What are the first name and major of the students who are able to consume soy?
SQL:
SELECT fname ,  major FROM Student WHERE StuID NOT IN (SELECT StuID FROM Has_allergy WHERE Allergy  =  "Soy")