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

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" "T1" JOIN "player" "T2" ON "T1"."Club_ID" = "T2"."Club_ID" GROUP BY "T1"."name"