How many film market estimations are there in record?
select count(*) from film_market_estimation
Show me the ones in the year of 1995.
select * from film_market_estimation where year = 1995
Give me the distinct directors of films in those estimations.
select distinct t1.director from film as t1 join film_market_estimation as t2 on t1.film_id = t2.film_id where t2.year = 1995