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)

A bar chart showing the average of capacity of cinemas open for each year, sort in asc by the names.
SELECT Openning_year, AVG(Capacity) FROM cinema GROUP BY Openning_year ORDER BY Openning_year
SELECT "Openning_year", AVG("Capacity") FROM "cinema" GROUP BY "Openning_year" ORDER BY "Openning_year" NULLS FIRST