CREATE TABLE player_coach (Player_ID INT, Coach_ID INT, Starting_year INT)
CREATE TABLE match_result (Rank INT, Club_ID INT, Gold INT, Big_Silver INT, Small_Silver INT, Bronze INT, Points INT)
CREATE TABLE player (Player_ID INT, Sponsor_name TEXT, Player_name TEXT, Gender TEXT, Residence TEXT, Occupation TEXT, Votes INT, Rank TEXT)
CREATE TABLE coach (Coach_ID INT, Coach_name TEXT, Gender TEXT, Club_ID INT, Rank INT)
CREATE TABLE club (Club_ID INT, Club_name TEXT, Region TEXT, Start_year INT)

Show different occupations along with the number of players in each occupation with a bar chart, and sort by the Y in descending.
SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC
SELECT "Occupation", COUNT(*) FROM "player" GROUP BY "Occupation" ORDER BY COUNT(*) DESC NULLS LAST