CREATE TABLE film (Studio VARCHAR2)

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