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)
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 club_rank (Rank FLOAT, Club_ID INT, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)

For all players, show the number of different club names they come from, and rank by the bars from low to high.
SELECT T1.name, COUNT(T1.name) FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID GROUP BY T1.name ORDER BY T1.name
SELECT "T1"."name", COUNT("T1"."name") FROM "club" AS "T1" JOIN "player" AS "T2" ON "T1"."Club_ID" = "T2"."Club_ID" GROUP BY "T1"."name" ORDER BY "T1"."name" NULLS FIRST