instruction: Plot the total number by grouped by competition type as a bar graph, and display names in descending order.
response: SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type ORDER BY Competition_type DESC