Please show me the names and years of the movies that has the top 3 highest rating stars
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
Yes, director names, movie names and years please.
select t2.title, t2.year, t2.director from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars desc limit 3
Please give me the same information for the movies that have the 3 lowest rating stars.
select t2.title, t2.year, t2.director from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars limit 3