Show me the titles all the movies.
select title from movie
What are their ratings?
select t2.title, t1.stars from rating as t1 join movie as t2 on t1.mid = t2.mid
Show me the names and years of the movies that has the top 3 rating star.
select t2.title, t2.year from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars desc limit 3