Database: city_record
Question: For each competition, count the number of matches.
SQL:
SELECT count(*) ,  Competition FROM MATCH GROUP BY Competition