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

What are the titles of all movies that James Cameron directed after 2000?
SELECT title FROM movie WHERE director = 'James Cameron' AND year > 2000
SELECT "title" FROM "movie" WHERE "director" = 'James Cameron' AND "year" > 2000