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

List all directors along with the number of films directed by each director Plot them as bar chart, sort in desc by the total number.
SELECT Directed_by, COUNT(*) FROM film GROUP BY Directed_by ORDER BY COUNT(*) DESC
SELECT "Directed_by", COUNT(*) FROM "film" GROUP BY "Directed_by" ORDER BY COUNT(*) DESC NULLS LAST