Use a group line chart to show how many competitions are held in each year, group by official name and bin by year, and display from low to high by the X.
CREATE TABLE farm (
    Farm_ID int,
    Year int,
    Total_Horses real,
    Working_Horses real,
    Total_Cattle real,
    Oxen real,
    Bulls real,
    Cows real,
    Pigs real,
    Sheep_and_Goats real
)

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 real,
    Population real,
    Census_Ranking text
)

CREATE TABLE farm_competition (
    Competition_ID int,
    Year int,
    Theme text,
    Host_city_ID int,
    Hosts text
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Use a group line chart to show how many competitions are held in each year, group by official name and bin by year, and display from low to high by the X. ### Input: CREATE TABLE farm (
    Farm_ID int,
    Year int,
    Total_Horses real,
    Working_Horses real,
    Total_Cattle real,
    Oxen real,
    Bulls real,
    Cows real,
    Pigs real,
    Sheep_and_Goats real
)

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 real,
    Population real,
    Census_Ranking text
)

CREATE TABLE farm_competition (
    Competition_ID int,
    Year int,
    Theme text,
    Host_city_ID int,
    Hosts text
) ### Response: 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