 A bar chart showing the average of capacity of cinemas open for each year, sort in asc by the names.
CREATE TABLE cinema (
    Cinema_ID int,
    Name text,
    Openning_year int,
    Capacity int,
    Location text
)

CREATE TABLE film (
    Film_ID int,
    Rank_in_series int,
    Number_in_season int,
    Title text,
    Directed_by text,
    Original_air_date text,
    Production_code text
)

CREATE TABLE schedule (
    Cinema_ID int,
    Film_ID int,
    Date text,
    Show_times_per_day int,
    Price float
)
SELECT Openning_year, AVG(Capacity) FROM cinema GROUP BY Openning_year ORDER BY Openning_year