What are all the movies?
select title from movie
What are their average ratings?
select t2.title, avg(t1.stars) from rating as t1 join movie as t2 on t1.mid = t2.mid group by t1.mid
Give me the movies with the lowest average rating.
select t2.title, 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) limit 1