CREATE TABLE club (club_id NUMBER, name CLOB, region CLOB, start_year CLOB)
CREATE TABLE competition (competition_id NUMBER, year NUMBER, competition_type CLOB, country CLOB)
CREATE TABLE club_rank (rank NUMBER, club_id NUMBER, gold NUMBER, silver NUMBER, bronze NUMBER, total NUMBER)
CREATE TABLE player (player_id NUMBER, name CLOB, position CLOB, club_id NUMBER, apps NUMBER, tries NUMBER, goals CLOB, points NUMBER)
CREATE TABLE competition_result (competition_id NUMBER, club_id_1 NUMBER, club_id_2 NUMBER, score CLOB)

What are the names and players of all the clubs?
SELECT T1.name, T2.player_id FROM club AS T1 JOIN player AS T2 ON T1.club_id = T2.club_id
SELECT "T1"."name", "T2"."player_id" FROM "club" "T1" JOIN "player" "T2" ON "T1"."club_id" = "T2"."club_id"