how many movies are there in total?
select count ( * ) from movie
What year did the oldest movie come out?
select year from movie order by year limit 1
How about the most recent one?
select year from movie order by year desc limit 1
What's the name of that movie?
select title from movie where year = ( select max ( year ) from movie )
yes
select director from movie where title = "Avatar"