CREATE TABLE farm (farm_id DECIMAL, year DECIMAL, total_horses DECIMAL, working_horses DECIMAL, total_cattle DECIMAL, oxen DECIMAL, bulls DECIMAL, cows DECIMAL, pigs DECIMAL, sheep_and_goats DECIMAL)
CREATE TABLE farm_competition (competition_id DECIMAL, year DECIMAL, theme TEXT, host_city_id DECIMAL, hosts TEXT)
CREATE TABLE city (city_id DECIMAL, official_name TEXT, status TEXT, area_km_2 DECIMAL, population DECIMAL, census_ranking TEXT)
CREATE TABLE competition_record (competition_id DECIMAL, farm_id DECIMAL, rank DECIMAL)

Show the years and the official names of the host cities of competitions.
SELECT T2.year, T1.official_name FROM city AS T1 JOIN farm_competition AS T2 ON T1.city_id = T2.host_city_id
SELECT "T2"."year", "T1"."official_name" FROM "city" AS "T1" JOIN "farm_competition" AS "T2" ON "T1"."city_id" = "T2"."host_city_id"