What are the movie titles and average rating of 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
yes
select year, director from movie where title = 'The sound of Music'
Yes
select t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid group by t1.mid order by t1.stars desc limit 1