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