Show the title and director for all movies.
select title, director from movie
Only show the results for those in the year 2000 or before.
select title, director from movie where year <= 2000
Order the results by the worldwide gross in descending order.
select title, director from movie where year <= 2000 order by gross_worldwide desc
Which one has the highest?
select title, director from movie where year <= 2000 order by gross_worldwide desc limit 1