What is it's rating?
select avg ( t1.stars ) from rating as t1 join movie as t2 on t1.mid = t2.mid group by t1.mid order by avg ( t1.stars ) desc limit 1
What is the average rating for all movies?
select t2.title ,avg ( t1.stars ) from rating as t1 join movie as t2 on t1.mid = t2.mid group by t1.mid
Which movie has the lowest rating?
select t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid where t1.stars = ( select min ( stars ) from rating )