instruction: Please draw a histogram to show the total number of participants in each type code, and sort Y from high to low order.
response: SELECT Participant_Type_Code, COUNT(Participant_Type_Code) FROM Participants GROUP BY Participant_Type_Code ORDER BY COUNT(Participant_Type_Code) DESC