
CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	"Home Town" TEXT, 
	PRIMARY KEY ("People_ID")
)


CREATE TABLE perpetrator (
	"Perpetrator_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Date" TEXT, 
	"Year" REAL, 
	"Location" TEXT, 
	"Country" TEXT, 
	"Killed" INTEGER, 
	"Injured" INTEGER, 
	PRIMARY KEY ("Perpetrator_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

CREATE TABLE people (
	"People_ID" INTEGER, 
	"Name" TEXT, 
	"Height" REAL, 
	"Weight" REAL, 
	"Home Town" TEXT, 
	PRIMARY KEY ("People_ID")
)

/*
2 rows from people table:
People_ID	Name	Height	Weight	Home Town
1	Ron Baxter	6.4	205.0	Los Angeles, CA
2	Brent Boyd	6.3	185.0	Baton Rouge, LA
*/


CREATE TABLE perpetrator (
	"Perpetrator_ID" INTEGER, 
	"People_ID" INTEGER, 
	"Date" TEXT, 
	"Year" REAL, 
	"Location" TEXT, 
	"Country" TEXT, 
	"Killed" INTEGER, 
	"Injured" INTEGER, 
	PRIMARY KEY ("Perpetrator_ID"), 
	FOREIGN KEY("People_ID") REFERENCES people ("People_ID")
)

/*
2 rows from perpetrator table:
Perpetrator_ID	People_ID	Date	Year	Location	Country	Killed	Injured
1	1	04.26 April 26/27	1982.0	Uiryeong	South Korea	56	37
2	3	11.18 Nov. 18	1995.0	Zhaodong	China	32	16
*/
Show the countries that have both perpetrators with injures more than 50 and perpetrators with injures smaller than 20.
SELECT Country FROM perpetrator WHERE Injured  >  50 INTERSECT SELECT Country FROM perpetrator WHERE Injured  <  20
[{'Country': 'China'}]