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_result (Competition_ID INT, Club_ID_1 INT, Club_ID_2 INT, Score TEXT)
CREATE TABLE competition (Competition_ID INT, Year FLOAT, Competition_type TEXT, Country TEXT)
CREATE TABLE club (Club_ID INT, name TEXT, Region TEXT, Start_year TEXT)

How many competitions in each competition type? And split them by country, and could you sort in ascending by the names?
SELECT Country, COUNT(Country) FROM competition GROUP BY Competition_type, Country ORDER BY Country
SELECT "Country", COUNT("Country") FROM "competition" GROUP BY "Competition_type", "Country" ORDER BY "Country" NULLS FIRST