List the studios of each film and the number of films produced by that studio.
CREATE TABLE film (Studio VARCHAR)
SELECT Studio, COUNT(*) FROM film GROUP BY Studio
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE film (Studio VARCHAR) Question: List the studios of each film and the number of films produced by that studio. [/INST] SELECT Studio, COUNT(*) FROM film GROUP BY Studio </s>