CREATE TABLE film (Film_ID NUMBER, Rank_in_series NUMBER, Number_in_season NUMBER, Title CLOB, Directed_by CLOB, Original_air_date CLOB, Production_code CLOB)
CREATE TABLE schedule (Cinema_ID NUMBER, Film_ID NUMBER, Date CLOB, Show_times_per_day NUMBER, Price FLOAT)
CREATE TABLE cinema (Cinema_ID NUMBER, Name CLOB, Openning_year NUMBER, Capacity NUMBER, Location CLOB)

Tell me how many cinemas open for each year in a bar chart, and display by the the number of openning year from high to low.
SELECT Openning_year, COUNT(Openning_year) FROM cinema GROUP BY Openning_year ORDER BY COUNT(Openning_year) DESC
SELECT "Openning_year", COUNT("Openning_year") FROM "cinema" GROUP BY "Openning_year" ORDER BY COUNT("Openning_year") DESC