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)
CREATE TABLE coach (Coach_ID NUMBER, Coach_name CLOB, Gender CLOB, Club_ID NUMBER, Rank NUMBER)
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)

Draw a bar chart of gender versus the number of gender, and rank by the Y in asc.
SELECT Gender, COUNT(Gender) FROM player GROUP BY Gender ORDER BY COUNT(Gender)
SELECT "Gender", COUNT("Gender") FROM "player" GROUP BY "Gender" ORDER BY COUNT("Gender")