
CREATE TABLE game (
	stadium_id INTEGER, 
	id INTEGER, 
	"Season" INTEGER, 
	"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 INTEGER, 
	id INTEGER, 
	"Player" TEXT, 
	"Injury" TEXT, 
	"Number_of_matches" TEXT, 
	"Source" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY(game_id) REFERENCES game (id)
)


CREATE TABLE stadium (
	id INTEGER, 
	name TEXT, 
	"Home_Games" INTEGER, 
	"Average_Attendance" REAL, 
	"Total_Attendance" REAL, 
	"Capacity_Percentage" REAL, 
	PRIMARY KEY (id)
)

CREATE TABLE game (
	stadium_id INTEGER, 
	id INTEGER, 
	"Season" INTEGER, 
	"Date" TEXT, 
	"Home_team" TEXT, 
	"Away_team" TEXT, 
	"Score" TEXT, 
	"Competition" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY(stadium_id) REFERENCES stadium (id)
)

/*
2 rows from game table:
stadium_id	id	Season	Date	Home_team	Away_team	Score	Competition
1	1	2007	18 May 2007	Quruvchi	Pakhtakor	1–1	League
2	2	2007	22 September 2007	Pakhtakor	Quruvchi	0–0	League
*/


CREATE TABLE injury_accident (
	game_id INTEGER, 
	id INTEGER, 
	"Player" TEXT, 
	"Injury" TEXT, 
	"Number_of_matches" TEXT, 
	"Source" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY(game_id) REFERENCES game (id)
)

/*
2 rows from injury_accident table:
game_id	id	Player	Injury	Number_of_matches	Source
1	1	Davide Santon	Clean-up surgery on his right knee	12	inter.it
2	2	Maicon	Knee problem	2	inter.it
*/


CREATE TABLE stadium (
	id INTEGER, 
	name TEXT, 
	"Home_Games" INTEGER, 
	"Average_Attendance" REAL, 
	"Total_Attendance" REAL, 
	"Capacity_Percentage" REAL, 
	PRIMARY KEY (id)
)

/*
2 rows from stadium table:
id	name	Home_Games	Average_Attendance	Total_Attendance	Capacity_Percentage
1	Cowboys Stadium	8	87047.0	696377.0	108.8
2	FedExField	8	83172.0	665380.0	90.7
*/
What are the ids, scores, and dates of the games which caused at least two injury accidents?
SELECT T1.id ,  T1.score ,  T1.date FROM game AS T1 JOIN injury_accident AS T2 ON T2.game_id  =  T1.id GROUP BY T1.id HAVING count(*)  >=  2
[{'id': 5, 'Score': '1–1', 'Date': '16 August 2008'}, {'id': 6, 'Score': '3–1', 'Date': '31 October 2008'}, {'id': 10, 'Score': '2–1', 'Date': '14 March 2010'}]