Show me the name of all the movies.
select title from movie
What about those that were made before 1980?
select title from movie where year < 1980
Please also include those that were directed by James Cameron.
select title from movie where director = "James Cameron" or year < 1980