Which coaches are rank in the 1st and 2nd place?
select coach_name from coach where rank < 3
Which coach is the 1st, show the name of the coach?
select coach_name from coach where rank = 1
What are the names of players of that coach?
select t3.player_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 t2.rank = 1