How many film market estimations are there?
select count(*) from film_market_estimation
Show me the year eash estimation was made.
select year from film_market_estimation
What about those in the market Japan?
select t1.year from film_market_estimation as t1 join market as t2 on t1.market_id = t2.market_id where t2.country = "Japan"
List them in descending order.
select t1.year from film_market_estimation as t1 join market as t2 on t1.market_id = t2.market_id where t2.country = "Japan" order by t1.year desc