Table schema:
CREATE TABLE film (Studio VARCHAR)

Question: List the studios of each film and the number of films produced by that studio.
SQL: SELECT Studio, COUNT(*) FROM film GROUP BY Studio