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
names and players of all the clubs involves joining two tables: club and player; the common attribute for the join is Club_ID; name refers to the club name; players refer to Player_id associated with each club;