What are all the different allergy types?
select distinct allergytype from allergy_type
Order them by number of allergies descendingly.
select allergytype from allergy_type group by allergytype order by count(*) desc
Which one has the most?
select allergytype from allergy_type group by allergytype order by count(*) desc limit 1