List the name of players
select player_name from player
How many coaches in total?
select count(*) from coach
Show the name of each player and also the corresponding coach name of each.
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
Who is Ross Eadie's coach?
select 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 t3.player_name = 'Ross Eadie'
List all the player-coach name pair with the vote of players, in descending order.
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 order by t3.votes desc