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
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.
PRAGMA foreign_keys = ON;


CREATE TABLE "stadium" (
"id" int,
"name" text,
"Home_Games" int,
"Average_Attendance" real,
"Total_Attendance" real,
"Capacity_Percentage" real,
primary key ("id")
);

CREATE TABLE "game" (
"stadium_id" int,
"id" int,
"Season" int,
"Date" text,
"Home_team" text,
"Away_team" text,
"Score" text,
"Competition" text,
primary key ("id"),
foreign key ("stadium_id") references `stadium`("id")
);

CREATE TABLE "injury_accident" (
"game_id" int,
"id" int,
"Player" text,
"Injury" text,
"Number_of_matches" text,
"Source" text,
primary key ("id"),
foreign key ("game_id") references `game`("id")
);







INSERT INTO  "stadium" VALUES (1,"Cowboys Stadium","8","87047","696377","108.8");
INSERT INTO  "game" VALUES (1,1,"2007","18 May 2007","Quruvchi","Pakhtakor","1–1","League");
INSERT INTO  "injury_accident" VALUES (1,1,"Davide Santon","Clean-up surgery on his right knee","12","inter.it");
