CREATE TABLE film (film_id NUMBER, title CLOB, studio CLOB, director CLOB, gross_in_dollar NUMBER)
CREATE TABLE market (market_id NUMBER, country CLOB, number_cities NUMBER)
CREATE TABLE film_market_estimation (estimation_id NUMBER, low_estimate NUMBER, high_estimate NUMBER, film_id NUMBER, type CLOB, market_id NUMBER, year NUMBER)

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"