List the name of players
select player_name from player
Show the name of each player and also the corresponding coach name.
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
Which pair starts before 2012?
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 where t1.starting_year < 2012
What about after 2011?
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 where t1.starting_year > 2011
Only show the player names and genders of those results.
select t3.player_name, t3.gender 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 where t1.starting_year > 2011