human
Schema:
county_public_safety (County_ID, Name, Population, Police_officers, Residents_per_officer, Case_burden, Crime_rate, Police_force, Location)
city (City_ID, County_ID, Name, White, Black, Amerindian, Asian, Multiracial, Hispanic)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the laargest white percentage among all cities?
assistant
SELECT MAX( White ) FROM city;
human
How many cities have a white percentage of more than 90?
assistant
SELECT COUNT( * ) FROM city WHERE White > 90;
human
What is the id of the county this city is located in?
assistant
SELECT County_ID FROM city WHERE White > 90;
human
What is this county's crime rate?
assistant
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 ;