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 gender of the students who have allergy to milk but can put up with cats?
SELECT fname, sex FROM student WHERE stuid IN (SELECT stuid FROM has_allergy WHERE allergy = "Milk" EXCEPT SELECT stuid FROM has_allergy WHERE allergy = "Cat")
SELECT "fname", "sex" FROM "student" WHERE "stuid" IN (SELECT "stuid" FROM "has_allergy" WHERE "Milk" = "allergy" EXCEPT SELECT "stuid" FROM "has_allergy" WHERE "Cat" = "allergy")