How many students are over 18 and do not have allergy to food type or animal type?
CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE allergy_type (
    allergy text,
    allergytype text
)

CREATE TABLE has_allergy (
    stuid number,
    allergy text
)
SELECT COUNT(*) FROM student WHERE age > 18 AND NOT stuid IN (SELECT stuid FROM has_allergy AS T1 JOIN allergy_type AS T2 ON T1.allergy = T2.allergy WHERE T2.allergytype = "food" OR T2.allergytype = "animal")
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many students are over 18 and do not have allergy to food type or animal type? ### Input: CREATE TABLE student (
    stuid number,
    lname text,
    fname text,
    age number,
    sex text,
    major number,
    advisor number,
    city_code text
)

CREATE TABLE allergy_type (
    allergy text,
    allergytype text
)

CREATE TABLE has_allergy (
    stuid number,
    allergy text
) ### Response: SELECT COUNT(*) FROM student WHERE age > 18 AND NOT stuid IN (SELECT stuid FROM has_allergy AS T1 JOIN allergy_type AS T2 ON T1.allergy = T2.allergy WHERE T2.allergytype = "food" OR T2.allergytype = "animal")