Database: city_record
Question: Find the number of matches in different competitions.
SQL:
SELECT count(*) ,  Competition FROM MATCH GROUP BY Competition