SCHEMA:
CREATE TABLE Allergy_type (allergy VARCHAR, allergytype VARCHAR)
USER:
Show all allergies with type food.

QUERY:
SELECT DISTINCT allergy FROM Allergy_type WHERE allergytype = "food"