Database: film_rank
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