1.6 · Challenge

Find Last Year's Release

In this final challenge, you will combine everything from this lab —date truncation, duration arithmetic, and range comparisons —to find movies released last year without hardcoding the year.

A new movie has been added to the database. It was released last year. Write a query to find it using temporal functions that adapt to the current date.