CREATE TABLE allergy_type (allergy CLOB, allergytype CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE has_allergy (stuid NUMBER, allergy CLOB)

What are the first name and major of the students who are able to consume soy?
SELECT fname, major FROM student WHERE NOT stuid IN (SELECT stuid FROM has_allergy WHERE allergy = "Soy")
SELECT "fname", "major" FROM "student" WHERE NOT "stuid" IN (SELECT "stuid" FROM "has_allergy" WHERE "Soy" = "allergy")