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