CREATE TABLE club (Club_ID NUMBER, Club_name CLOB, Region CLOB, Start_year NUMBER)
CREATE TABLE player_coach (Player_ID NUMBER, Coach_ID NUMBER, Starting_year 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 match_result (Rank NUMBER, Club_ID NUMBER, Gold NUMBER, Big_Silver NUMBER, Small_Silver NUMBER, Bronze NUMBER, Points NUMBER)

Compare the distribution of the players' gender using a bar chart, and could you display in ascending by the x axis?
SELECT Gender, COUNT(Gender) FROM player GROUP BY Gender ORDER BY Gender
SELECT "Gender", COUNT("Gender") FROM "player" GROUP BY "Gender" ORDER BY "Gender"