Database: sports_competition
Question: List the types of competition and the number of competitions of each type.
SQL:
SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type