CREATE TABLE city (City_ID INT, City TEXT, Hanzi TEXT, Hanyu_Pinyin TEXT, Regional_Population INT, GDP FLOAT)
CREATE TABLE match (Match_ID INT, Date TEXT, Venue TEXT, Score TEXT, Result TEXT, Competition TEXT)
CREATE TABLE hosting_city (Year INT, Match_ID INT, Host_City TEXT)
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)

Find the number of matches in different competitions Visualize by bar chart, I want to rank Y in asc order.
SELECT Competition, COUNT(*) FROM match GROUP BY Competition ORDER BY COUNT(*)
SELECT "Competition", COUNT(*) FROM "match" GROUP BY "Competition" ORDER BY COUNT(*) NULLS FIRST