
CREATE TABLE city (
	"City_ID" INTEGER, 
	"County_ID" INTEGER, 
	"Name" TEXT, 
	"White" REAL, 
	"Black" REAL, 
	"Amerindian" REAL, 
	"Asian" REAL, 
	"Multiracial" REAL, 
	"Hispanic" REAL, 
	PRIMARY KEY ("City_ID"), 
	FOREIGN KEY("County_ID") REFERENCES county_public_safety ("County_ID")
)


CREATE TABLE county_public_safety (
	"County_ID" INTEGER, 
	"Name" TEXT, 
	"Population" INTEGER, 
	"Police_officers" INTEGER, 
	"Residents_per_officer" INTEGER, 
	"Case_burden" INTEGER, 
	"Crime_rate" REAL, 
	"Police_force" TEXT, 
	"Location" TEXT, 
	PRIMARY KEY ("County_ID")
)

CREATE TABLE city (
	"City_ID" INTEGER, 
	"County_ID" INTEGER, 
	"Name" TEXT, 
	"White" REAL, 
	"Black" REAL, 
	"Amerindian" REAL, 
	"Asian" REAL, 
	"Multiracial" REAL, 
	"Hispanic" REAL, 
	PRIMARY KEY ("City_ID"), 
	FOREIGN KEY("County_ID") REFERENCES county_public_safety ("County_ID")
)

/*
2 rows from city table:
City_ID	County_ID	Name	White	Black	Amerindian	Asian	Multiracial	Hispanic
1	1	Adjuntas	93.1	3.1	0.3	0.0	3.4	99.6
2	1	Aguada	86.6	5.3	0.3	0.1	7.7	99.4
*/


CREATE TABLE county_public_safety (
	"County_ID" INTEGER, 
	"Name" TEXT, 
	"Population" INTEGER, 
	"Police_officers" INTEGER, 
	"Residents_per_officer" INTEGER, 
	"Case_burden" INTEGER, 
	"Crime_rate" REAL, 
	"Police_force" TEXT, 
	"Location" TEXT, 
	PRIMARY KEY ("County_ID")
)

/*
2 rows from county_public_safety table:
County_ID	Name	Population	Police_officers	Residents_per_officer	Case_burden	Crime_rate	Police_force	Location
1	Abbotsford	128165	187	685	81	118.0	Abbotsford Police Department	East
2	Burnaby	204320	253	808	100	123.0	RCMP	East
*/
Show the crime rate of counties with a city having white percentage more than 90.
SELECT T2.Crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID WHERE T1.White  >  90
[{'Crime_rate': 118.0}]