CREATE TABLE hosting_city (host_city VARCHAR, year INT)
CREATE TABLE city (city VARCHAR, city_id VARCHAR)

Find the cities which were once 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
SELECT "T1"."city" FROM "city" AS "T1" JOIN "hosting_city" AS "T2" ON "T1"."city_id" = "T2"."host_city" AND "T2"."year" > 2010