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