Find the movie id of Gone with the Wind?
select mid from movie where title = 'Gone with the Wind'
Which year Star Wars movie is released?
select year from movie where title = 'Star Wars'
Who is directed by The Sound of Music?
select director from movie where title = 'The sound of Music'
What is the name of the movie produced after 2000 and directed by James Cameron?
select title from movie where director = 'James Cameron' and year > 2000