Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE city ( City_ID int, City text, Hanzi text, Hanyu_Pinyin text, Regional_Population int, GDP real )
TABLE: CREATE TABLE match ( Match_ID int, Date text, Venue text, Score text, Result text, Competition text )
TABLE: CREATE TABLE hosting_city ( Year int, Match_ID int, Host_City text )
TABLE: CREATE TABLE temperature ( City_ID int, Jan real, Feb real, Mar real, Apr real, Jun real, Jul real, Aug real, Sep real, Oct real, Nov real, Dec real )

### Question ###
Find the number of matches in different competitions Visualize by bar chart, I want to rank Y in asc order.

### Accurate SQL ###

SELECT Competition, COUNT(*) FROM match GROUP BY Competition ORDER BY COUNT(*)