What are the names of the movies?
select title from movie
Which are made before 1980?
select title from movie where year < 1980
From the list of all movies, which were directed by James Cameron?
select title from movie where director = "James Cameron"