List the types of competition and the number of competitions of each type.
SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type
SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type
[{'Competition_type': 'Friendly', 'COUNT(*)': 8}, {'Competition_type': 'Tournament', 'COUNT(*)': 3}]