For all players, show the number of different club names they come from, and rank by the bar in desc.
CREATE TABLE club_rank (
    Rank real,
    Club_ID int,
    Gold real,
    Silver real,
    Bronze real,
    Total real
)

CREATE TABLE competition (
    Competition_ID int,
    Year real,
    Competition_type text,
    Country text
)

CREATE TABLE competition_result (
    Competition_ID int,
    Club_ID_1 int,
    Club_ID_2 int,
    Score 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 real,
    Tries real,
    Goals text,
    Points real
)
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 DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: For all players, show the number of different club names they come from, and rank by the bar in desc. ### Input: CREATE TABLE club_rank (
    Rank real,
    Club_ID int,
    Gold real,
    Silver real,
    Bronze real,
    Total real
)

CREATE TABLE competition (
    Competition_ID int,
    Year real,
    Competition_type text,
    Country text
)

CREATE TABLE competition_result (
    Competition_ID int,
    Club_ID_1 int,
    Club_ID_2 int,
    Score 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 real,
    Tries real,
    Goals text,
    Points real
) ### Response: 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 DESC