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

What are names of the movies that are either made before 1980 or directed by James Cameron?
SELECT title FROM movie WHERE director = "James Cameron" OR year < 1980
SELECT "title" FROM "movie" WHERE "James Cameron" = "director" OR "year" < 1980