CREATE TABLE player_coach (Coach_ID VARCHAR, Player_ID VARCHAR)
CREATE TABLE player (Player_name VARCHAR, Player_ID VARCHAR)
CREATE TABLE coach (coach_name VARCHAR, Coach_ID VARCHAR)

Show the names of players and names of their coaches.
SELECT T3.Player_name, T2.coach_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID = T2.Coach_ID JOIN player AS T3 ON T1.Player_ID = T3.Player_ID
SELECT "T3"."Player_name", "T2"."coach_name" FROM "player_coach" AS "T1" JOIN "coach" AS "T2" ON "T1"."Coach_ID" = "T2"."Coach_ID" JOIN "player" AS "T3" ON "T1"."Player_ID" = "T3"."Player_ID"