Translate the following question to SQL: What are the names of all movies made before 1980 or had James Cameron as the director?

Schema: CREATE TABLE Movie (
    mID INT   PRIMARY KEY,
    title TEXT,
    year INT,
    director TEXT,
    UNIQUE (mID)
);

CREATE TABLE Reviewer (
    rID INT   PRIMARY KEY,
    name TEXT,
    UNIQUE (rID)
);

CREATE TABLE Rating (
    rID INT,
    mID INT,
    stars INT,
    ratingDate date,
    FOREIGN KEY (rID) REFERENCES Reviewer(rID),
    FOREIGN KEY (mID) REFERENCES Movie(mID)
);
user
SELECT title FROM Movie WHERE director  =  "James Cameron" OR YEAR   <  1980
assistant