แสดงชื่อผู้เล่นและชื่อโค้ชตามลำดับคะแนนโหวตของผู้เล่นจากมากไปหาน้อย ไม่จำเป็นต้องใช้ตารางทั้งหมด
Show the names of players and names of their coaches in descending order of the votes of players.It is not neccessary to use all the tables.
 coach:  (coach_name [ VARCHAR ] Coach_ID [ VARCHAR) ]
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