Can you give me the names of the movies that has the top 3 highest rating star?
select t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars desc limit 3
Can you show me the years of those movies as well?
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
How about their directors?
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
Can you add rating stars too?
select t2.title, t2.year, t2.director, t1.stars from rating as t1 join movie as t2 on t1.mid = t2.mid order by t1.stars desc limit 3
Can you please tell me the average stars as well?
select avg ( stars ) from rating