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 the names of all movies made before 1980 or had James Cameron as the director?
SELECT title FROM movie WHERE director = "James Cameron" OR year < 1980
SELECT "title" FROM "movie" WHERE "James Cameron" = "director" OR "year" < 1980