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 country ( Country_id int, Country_name text, Capital text, Official_native_language text )
TABLE: CREATE TABLE team ( Team_id int, Name text )
TABLE: CREATE TABLE player ( Player_ID int, Player text, Years_Played text, Total_WL text, Singles_WL text, Doubles_WL text, Team int )
TABLE: CREATE TABLE match_season ( Season real, Player text, Position text, Country int, Team int, Draft_Pick_Number int, Draft_Class text, College text )

### Question ###
Give me a bar chart for the total number of each position, rank from high to low by the Y-axis.

### Accurate SQL ###

SELECT Position, COUNT(*) FROM match_season GROUP BY Position ORDER BY COUNT(*) DESC