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

Give me a bar chart showing the number of films for each director, and display bar in asc order.
SELECT Directed_by, COUNT(Directed_by) FROM film GROUP BY Directed_by ORDER BY Directed_by
SELECT "Directed_by", COUNT("Directed_by") FROM "film" GROUP BY "Directed_by" ORDER BY "Directed_by" NULLS FIRST