Database: sports_competition
Question: What are the types of competition and number of competitions for that type?
SQL:
SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type