human
Schema:
city (City_ID, City, Hanzi, Hanyu_Pinyin, Regional_Population, GDP)
match (Match_ID, Date, Venue, Score, Result, Competition)
temperature (City_ID, Jan, Feb, Mar, Apr, Jun, Jul, Aug, Sep, Oct, Nov, Dec)
hosting_city (Year, Match_ID, Host_City)
Please answer with SQL.
assistant
Sure, I understand.
human
Which city has the smallest GDP?
assistant
SELECT City FROM CITY ORDER BY gdp ASC LIMIT 1;
human
Which city has the largest population?
assistant
SELECT CITY FROM city ORDER BY Regional_Population DESC LIMIT 1 ;