Database: farm
Question: Give the years and official names of the cities of each competition.
SQL:
SELECT T2.Year ,  T1.Official_Name FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID  =  T2.Host_city_ID