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)
CREATE TABLE market (market_id NUMBER, country CLOB, number_cities NUMBER)

Count the number of markets that have a number of cities lower than 300.
SELECT COUNT(*) FROM market WHERE number_cities < 300
SELECT COUNT(*) FROM "market" WHERE "number_cities" < 300