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)
CREATE TABLE film (film_id NUMBER, title CLOB, studio CLOB, director CLOB, gross_in_dollar NUMBER)

List the studios which average gross is above 4500000.
SELECT studio FROM film GROUP BY studio HAVING AVG(gross_in_dollar) >= 4500000
SELECT "studio" FROM "film" GROUP BY "studio" HAVING AVG("gross_in_dollar") >= 4500000