Database: film_rank
Question: How films are produced by each studio?
SQL:
SELECT Studio ,  COUNT(*) FROM film GROUP BY Studio