How many film market estimations are there?
select count(*) from film_market_estimation
Show me the id of films that are in one of those estimations.
select distinct film_id from film_market_estimation
Show me the title of films that are not one of those.
select title from film where film_id not in (select film_id from film_market_estimation)