What are the names of the players?
select player_name from player
Who are 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
Show me these names in descending order based on number of player votes.
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
also Show me the gender of the coaches and players.
select t3.player_name, t3.gender, t2.coach_name, t2.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 order by t3.votes desc
How many votes did each player receive?
select player_name, votes from player
Please list this in descending order.
select player_name, votes from player order by votes desc