Show the names of the cities.
select city from city
Which of them were a host city after 2008?
select t1.city from city as t1 join hosting_city as t2 on t1.city_id = t2.host_city where t2.year > 2008
How about the cities that were a host city after 2010?
select t1.city from city as t1 join hosting_city as t2 on t1.city_id = t2.host_city where t2.year > 2010