List all directors along with the number of films directed by each director.
CREATE TABLE film (directed_by VARCHAR)
SELECT directed_by, COUNT(*) FROM film GROUP BY directed_by
### Context: CREATE TABLE film (directed_by VARCHAR) ### Question: List all directors along with the number of films directed by each director. ### Answer: SELECT directed_by, COUNT(*) FROM film GROUP BY directed_by