Table schema:
CREATE TABLE Has_allergy (Allergy VARCHAR)

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