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

Show different occupations along with the number of players in each occupation with a bar chart, and could you list Y-axis in ascending order please?
SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation ORDER BY COUNT(*)
SELECT "Occupation", COUNT(*) FROM "player" GROUP BY "Occupation" ORDER BY COUNT(*)