Schema: CREATE TABLE Has_allergy (Allergy VARCHAR)
Question: How many students have cat allergies?
SQL: SELECT COUNT(*) FROM Has_allergy WHERE Allergy = "Cat"