What are the name of all movies?
select title from movie
What rating star did each of them have?
select t2.title, t1.stars from rating as t1 join movie as t2 on t1.mid = t2.mid
Give me the movies that have rating star between 3 and 5.
select t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid where t1.stars between 3 and 5