SELECT count(*) FROM Has_allergy WHERE Allergy  =  "Cat"
How many students have cat allergies?
SELECT count ( * ) FROM Has_allergy WHERE Allergy = `` Cat ''
select count ( * ) from has_allergy where allergy = value
How many students have cat allergies ?