CREATE TABLE player (Player_name VARCHAR(255), Player_ID VARCHAR(255)); CREATE TABLE coach (coach_name VARCHAR(255), Coach_ID VARCHAR(255)); CREATE TABLE player_coach (Coach_ID VARCHAR(255), Player_ID VARCHAR(255))
Show the names of players and names of their coaches.
    
SQL: 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