CREATE TABLE club_rank (Rank FLOAT, Club_ID INT, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)
CREATE TABLE competition_result (Competition_ID INT, Club_ID_1 INT, Club_ID_2 INT, Score 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 (Competition_ID INT, Year FLOAT, Competition_type TEXT, Country TEXT)
CREATE TABLE club (Club_ID INT, name TEXT, Region TEXT, Start_year TEXT)

For all players, show the number of different club names they come from.
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
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"