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

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" "T1" JOIN "coach" "T2" ON "T1"."Coach_ID" = "T2"."Coach_ID" JOIN "player" "T3" ON "T1"."Player_ID" = "T3"."Player_ID"