For each competition, count the number of matches.
SELECT count(*) ,  Competition FROM MATCH GROUP BY Competition
SELECT count(*) ,  Competition FROM MATCH GROUP BY Competition
[{'count(*)': 4, 'Competition': '1994 FIFA World Cup qualification'}, {'count(*)': 1, 'Competition': '2002 FIFA World Cup qualification'}, {'count(*)': 1, 'Competition': 'Friendly match'}]