CREATE TABLE club (name VARCHAR(255), Club_ID VARCHAR(255)); CREATE TABLE player (Player_id VARCHAR(255), Club_ID VARCHAR(255))
Please show the names and the players of clubs.
    
SQL: SELECT T1.name, T2.Player_id FROM club AS T1 JOIN player AS T2 ON T1.Club_ID = T2.Club_ID