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

Stacked bar chart of the number of country for with each Competition_type in each country, order bar in desc order.
SELECT Country, COUNT(Country) FROM competition GROUP BY Competition_type, Country ORDER BY Country DESC
SELECT "Country", COUNT("Country") FROM "competition" GROUP BY "Competition_type", "Country" ORDER BY "Country" DESC NULLS LAST