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

What is the full name of each student who is not allergic to any type of food.
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")