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 match_result ( Rank int, Club_ID int, Gold int, Big_Silver int, Small_Silver int, Bronze int, Points int )
TABLE: CREATE TABLE club ( Club_ID int, Club_name text, Region text, Start_year int )
TABLE: CREATE TABLE player_coach ( Player_ID int, Coach_ID int, Starting_year int )
TABLE: CREATE TABLE coach ( Coach_ID int, Coach_name text, Gender text, Club_ID int, Rank int )
TABLE: CREATE TABLE player ( Player_ID int, Sponsor_name text, Player_name text, Gender text, Residence text, Occupation text, Votes int, Rank text )

### Question ###
Show different occupations along with the number of players in each occupation Show bar chart, and show y-axis from high to low order.

### Accurate SQL ###

SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC