How many allergy cases are there?
select count(*) from has_allergy
Of those, for how many is it a food allergy?
select count(*) from has_allergy as t1 join allergy_type as t2 on t1.allergy = t2.allergy where t2.allergytype = "food"