What are the titles of all movies?
select title from movie
Which one is the oldest?
select title from movie where year = (select min(year) from movie)
What is its average rating stars?
select avg(t1.stars), t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid where t2.year = (select min(year) from movie)