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
Hello, can you tell me which city hosted events in the most recent year? | Which attribute of the city do you want? | How about, what is the most recent year?
assistant
SELECT YEAR FROM hosting_city ORDER BY YEAR DESC LIMIT 1;
human
What was the match id in 2013?
assistant
SELECT MATCH_ID FROM hosting_city WHERE YEAR = 2013 ;