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 minimum white percentage of the counties?
assistant
SELECT White FROM city ORDER BY White ASC LIMIT 1;
human
How about the largest 5 white percentages?
assistant
SELECT White FROM city ORDER BY White DESC LIMIT 5;
human
List the names of their cities.
assistant
SELECT Name FROM city ORDER BY White DESC LIMIT 5 ;