Give me movies that are directed by James Cameron.
select title from movie where director = 'James Cameron'
What about those that also produced after 2000 at the same time?
select title from movie where director = 'James Cameron' and year > 2000