What is the name of the movie produced after 2000 and directed by James Cameron?
SELECT title FROM Movie WHERE director = 'James Cameron' AND YEAR  >  2000
produced after 2000 refers to YEAR > 2000; directed by James Cameron refers to director = 'James Cameron'; movie name refers to title;