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)
CREATE TABLE player_coach (Player_ID INT, Coach_ID INT, Starting_year INT)

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") NULLS FIRST