SELECT count(*) ,  Competition FROM MATCH GROUP BY Competition
For each competition, count the number of matches.
SELECT count ( * ) , Competition FROM MATCH GROUP BY Competition
select count ( * ) , competition from match group by competition
For each competition , count the number of matches .