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
### Context: CREATE TABLE film (Studio VARCHAR) ### Question: List the studios of each film and the number of films produced by that studio. ### Answer: SELECT Studio, COUNT(*) FROM film GROUP BY Studio