instruction: Give me a histogram for what are the types of competition and number of competitions for that type?, and order in asc by the the total number please.
response: SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type ORDER BY COUNT(*)