1. Learn
    2. /
  2. Courses
    3. /
  3. Data-Driven Decision Making in SQL

Exercise

Working with dates

For the analysis of monthly or annual changes, it is important to select data from specific time periods. You will select records from the table renting of movie rentals. The format of dates is 'YYYY-MM-DD'.

Instructions 1/3

undefined XP
  • 1
    • Select all movies rented on October 9th, 2018.
  • 2
    • Select all records of movie rentals between beginning of April 2018 till end of August 2018.
  • 3
    • Put the most recent records of movie rentals on top of the resulting table and order them in decreasing order.