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

Visualize a bar chart to show how many players in each occupation, and I want to list names in ascending order.
SELECT Occupation, COUNT(Occupation) FROM player GROUP BY Occupation ORDER BY Occupation
SELECT "Occupation", COUNT("Occupation") FROM "player" GROUP BY "Occupation" ORDER BY "Occupation"