human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the names of the movies?
assistant
SELECT title FROM Movie;
human
Which are made before 1980?
assistant
SELECT title FROM Movie WHERE YEAR < 1980;
human
From the list of all movies, which were directed by James Cameron?
assistant
SELECT title FROM Movie WHERE director = "James Cameron" ;