What are the title of all movies?
select title from movie
What about those without any rating?
select title from movie where mid not in (select mid from rating)