CREATE TABLE club (Club_ID INT, name TEXT, Region TEXT, Start_year TEXT)
CREATE TABLE player (Player_ID INT, name TEXT, Position TEXT, Club_ID INT, Apps FLOAT, Tries FLOAT, Goals TEXT, Points FLOAT)
CREATE TABLE club_rank (Rank FLOAT, Club_ID INT, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total 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)

A bar chart showing the number of different competition types, could you show from low to high by the bar please?
SELECT Competition_type, COUNT(Competition_type) FROM competition GROUP BY Competition_type ORDER BY Competition_type
SELECT "Competition_type", COUNT("Competition_type") FROM "competition" GROUP BY "Competition_type" ORDER BY "Competition_type" NULLS FIRST