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
Hi there! Can you show me a list of all of the cities including city IDs and city names?
assistant
SELECT City_ID , Name FROM city;
human
Oh, I am sorry about that. Can you please show me a list of all of the cities located in counties that for which the county has a population over 20,000?
assistant
SELECT Name FROM city WHERE county_ID IN ( SELECT county_ID FROM county_public_safety WHERE population > 20000 ) ;