CREATE TABLE farm (Farm_ID INT, Year INT, Total_Horses FLOAT, Working_Horses FLOAT, Total_Cattle FLOAT, Oxen FLOAT, Bulls FLOAT, Cows FLOAT, Pigs FLOAT, Sheep_and_Goats FLOAT)
CREATE TABLE competition_record (Competition_ID INT, Farm_ID INT, Rank INT)
CREATE TABLE farm_competition (Competition_ID INT, Year INT, Theme TEXT, Host_city_ID INT, Hosts TEXT)
CREATE TABLE city (City_ID INT, Official_Name TEXT, Status TEXT, Area_km_2 FLOAT, Population FLOAT, Census_Ranking TEXT)

Give the years and official names of the cities of each competition, and sort the number of year in descending order.
SELECT Year, COUNT(Year) FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID ORDER BY COUNT(Year) DESC
SELECT "Year", COUNT("Year") FROM "city" AS "T1" JOIN "farm_competition" AS "T2" ON "T1"."City_ID" = "T2"."Host_city_ID" ORDER BY COUNT("Year") DESC NULLS LAST