SELECT Studio ,  COUNT(*) FROM film GROUP BY Studio
How films are produced by each studio?
SELECT Studio , COUNT ( * ) FROM film GROUP BY Studio
select studio , count ( * ) from film group by studio
How films are produced by each studio ?