What are the titles of all movies?
select title from movie
Which one is the most recent?
select title from movie where year = (select max(year) from movie)
What is its highest rating stars?
select max(t1.stars), t2.title from rating as t1 join movie as t2 on t1.mid = t2.mid where t2.year = (select max(year) from movie)