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

Use a group line chart to show how many competitions are held in each year, group by official name and bin by year, and show by the Year in ascending.
SELECT Year, COUNT(Year) FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID GROUP BY Official_Name ORDER BY Year
SELECT "Year", COUNT("Year") FROM "city" "T1" JOIN "farm_competition" "T2" ON "T1"."City_ID" = "T2"."Host_city_ID" GROUP BY "Official_Name" ORDER BY "Year"