Show me the names of all movies.
select title from movie
What about those with 5 star rating?
select t1.title from movie as t1 join rating as t2 on t1.mid = t2.mid where t2.stars = 5
Who directed those movies?
select t1.director, t1.title from movie as t1 join rating as t2 on t1.mid = t2.mid where t2.stars = 5