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

Show each location and the number of cinemas there Show bar chart, sort y axis from high to low order.
SELECT Location, COUNT(*) FROM cinema GROUP BY Location ORDER BY COUNT(*) DESC
SELECT "Location", COUNT(*) FROM "cinema" GROUP BY "Location" ORDER BY COUNT(*) DESC