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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (directed_by VARCHAR) Question: List all directors along with the number of films directed by each director. [/INST] SELECT directed_by, COUNT(*) FROM film GROUP BY directed_by </s>