CREATE TABLE hosting_city (Year INT, Match_ID INT, Host_City TEXT)
CREATE TABLE match (Match_ID INT, Date TEXT, Venue TEXT, Score TEXT, Result TEXT, Competition TEXT)
CREATE TABLE city (City_ID INT, City TEXT, Hanzi TEXT, Hanyu_Pinyin TEXT, Regional_Population INT, GDP FLOAT)
CREATE TABLE temperature (City_ID INT, Jan FLOAT, Feb FLOAT, Mar FLOAT, Apr FLOAT, Jun FLOAT, Jul FLOAT, Aug FLOAT, Sep FLOAT, Oct FLOAT, Nov FLOAT, Dec FLOAT)

Bar chart x axis competition y axis the total number, and display by the X-axis in ascending.
SELECT Competition, COUNT(*) FROM match GROUP BY Competition ORDER BY Competition
SELECT "Competition", COUNT(*) FROM "match" GROUP BY "Competition" ORDER BY "Competition" NULLS FIRST