CREATE TABLE MATCH (Competition VARCHAR)

Find the number of matches in different competitions.
SELECT COUNT(*), Competition FROM MATCH GROUP BY Competition
SELECT COUNT(*), "Competition" FROM "MATCH" GROUP BY "Competition"