instruction: Draw a bar chart for how many students are affected by each allergy type?, show by the bar in descending.
response: SELECT AllergyType, COUNT(*) FROM Has_Allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy GROUP BY T2.AllergyType ORDER BY AllergyType DESC