Who have allergies?
select * from has_allergy
Who has a cat allergy?
select * from has_allergy where allergy = "Cat"
How many are there?
select count(*) from has_allergy where allergy = "Cat"