CREATE TABLE Student (fname VARCHAR2, lname VARCHAR2, StuID VARCHAR2)
CREATE TABLE Allergy_Type (Allergy VARCHAR2, allergytype VARCHAR2)
CREATE TABLE Has_allergy (StuID VARCHAR2, Allergy VARCHAR2)

List the first and last name of the students who do not have any food type allergy.
SELECT fname, lname FROM Student WHERE NOT StuID IN (SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food")
WITH "_u_0" AS (SELECT ARRAY_AGG("StuID") AS "", "T2"."allergytype" AS "_u_1" FROM "Has_allergy" "T1" JOIN "Allergy_Type" "T2" ON "T1"."Allergy" = "T2"."Allergy" GROUP BY "T2"."allergytype") SELECT "fname", "lname" FROM "Student" LEFT JOIN "_u_0" "_u_0" ON "_u_0"."_u_1" = "food" WHERE NOT ARRAY_ANY("_u_0"."", "_x" -> "StuID" = "_x")