CREATE TABLE reviewer (rid NUMBER, name CLOB)
CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)
CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)

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
SELECT "title" FROM "movie" WHERE "director" = 'James Cameron' AND "year" > 2000