CREATE TABLE match (match_id DECIMAL, date TEXT, venue TEXT, score TEXT, result TEXT, competition TEXT)
CREATE TABLE city (city_id DECIMAL, city TEXT, hanzi TEXT, hanyu_pinyin TEXT, regional_population DECIMAL, gdp DECIMAL)
CREATE TABLE hosting_city (year DECIMAL, match_id DECIMAL, host_city TEXT)
CREATE TABLE temperature (city_id DECIMAL, jan DECIMAL, feb DECIMAL, mar DECIMAL, apr DECIMAL, jun DECIMAL, jul DECIMAL, aug DECIMAL, sep DECIMAL, oct DECIMAL, nov DECIMAL, dec DECIMAL)

For each competition, count the number of matches.
SELECT COUNT(*), competition FROM match GROUP BY competition
SELECT COUNT(*), "competition" FROM "match" GROUP BY "competition"