CREATE TABLE competition (Competition_ID NUMBER, Year FLOAT, Competition_type CLOB, Country CLOB)
CREATE TABLE competition_result (Competition_ID NUMBER, Club_ID_1 NUMBER, Club_ID_2 NUMBER, Score CLOB)
CREATE TABLE club_rank (Rank FLOAT, Club_ID NUMBER, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)
CREATE TABLE club (Club_ID NUMBER, name CLOB, Region CLOB, Start_year CLOB)
CREATE TABLE player (Player_ID NUMBER, name CLOB, Position CLOB, Club_ID NUMBER, Apps FLOAT, Tries FLOAT, Goals CLOB, Points FLOAT)

Show me the number of country by country in a histogram, and rank by the y axis in ascending.
SELECT Country, COUNT(Country) FROM competition GROUP BY Country ORDER BY COUNT(Country)
SELECT "Country", COUNT("Country") FROM "competition" GROUP BY "Country" ORDER BY COUNT("Country")