CREATE TABLE schedule (Cinema_ID INT, Film_ID INT, Date TEXT, Show_times_per_day INT, Price FLOAT)
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 cinema (Cinema_ID INT, Name TEXT, Openning_year INT, Capacity INT, Location TEXT)

A bar chart showing the average price of each cinema, and list by the the average of price in ascending.
SELECT Name, AVG(Price) FROM schedule AS T1 JOIN film AS T2 ON T1.Film_ID = T2.Film_ID JOIN cinema AS T3 ON T1.Cinema_ID = T3.Cinema_ID GROUP BY Name ORDER BY AVG(Price)
SELECT "Name", AVG("Price") FROM "schedule" AS "T1" JOIN "film" AS "T2" ON "T1"."Film_ID" = "T2"."Film_ID" JOIN "cinema" AS "T3" ON "T1"."Cinema_ID" = "T3"."Cinema_ID" GROUP BY "Name" ORDER BY AVG("Price") NULLS FIRST