CREATE TABLE film (directed_by VARCHAR2)

List all directors along with the number of films directed by each director.
SELECT directed_by, COUNT(*) FROM film GROUP BY directed_by
SELECT "directed_by", COUNT(*) FROM "film" GROUP BY "directed_by"