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

Bar chart x axis competition y axis the total number, and could you rank in descending by the the total number ?
SELECT Competition, COUNT(*) FROM match GROUP BY Competition ORDER BY COUNT(*) DESC
SELECT "Competition", COUNT(*) FROM "match" GROUP BY "Competition" ORDER BY COUNT(*) DESC