CREATE TABLE club (club_id DECIMAL, club_name TEXT, region TEXT, start_year DECIMAL)
CREATE TABLE player_coach (player_id DECIMAL, coach_id DECIMAL, starting_year DECIMAL)
CREATE TABLE match_result (rank DECIMAL, club_id DECIMAL, gold DECIMAL, big_silver DECIMAL, small_silver DECIMAL, bronze DECIMAL, points DECIMAL)
CREATE TABLE coach (coach_id DECIMAL, coach_name TEXT, gender TEXT, club_id DECIMAL, rank DECIMAL)
CREATE TABLE player (player_id DECIMAL, sponsor_name TEXT, player_name TEXT, gender TEXT, residence TEXT, occupation TEXT, votes DECIMAL, rank TEXT)

Show the names of players and names of their coaches in descending order of the votes of players.
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
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 NULLS LAST