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

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