For each injury accident, find the date of the game and the name of the injured player in the game, and sort the results in descending order of game season.
SELECT T1.date ,  T2.player FROM game AS T1 JOIN injury_accident AS T2 ON T1.id  =  T2.game_id ORDER BY T1.season DESC
date of the game refers to T1.date; name of the injured player refers to T2.player; sort in descending order of game season refers to ORDER BY T1.season DESC; for each injury accident refers to JOIN operation between game and injury_accident tables on a common game_id;