CREATE TABLE competition_record (Competition_ID INT, Farm_ID INT, Rank INT)
CREATE TABLE city (City_ID INT, Official_Name TEXT, Status TEXT, Area_km_2 FLOAT, Population FLOAT, Census_Ranking TEXT)
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 farm_competition (Competition_ID INT, Year INT, Theme TEXT, Host_city_ID INT, Hosts TEXT)

Show how many competitions are held in each year with a line chart.
SELECT Year, COUNT(Year) FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID
SELECT "Year", COUNT("Year") FROM "city" AS "T1" JOIN "farm_competition" AS "T2" ON "T1"."City_ID" = "T2"."Host_city_ID"