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)
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)

Bar graph to show the number of directed by from different directed by, order by the y axis in asc.
SELECT Directed_by, COUNT(Directed_by) FROM film GROUP BY Directed_by ORDER BY COUNT(Directed_by)
SELECT "Directed_by", COUNT("Directed_by") FROM "film" GROUP BY "Directed_by" ORDER BY COUNT("Directed_by")