How about, what is the most recent year?
select year from hosting_city order by year desc limit 1
What was the match id in 2013?
select match_id from hosting_city where year = 2013
What is the city id that is associated with match id 6 in 2013?
select host_city from hosting_city where year = 2013