Exercise

Using CURRENT_TIMESTAMP

Another common question in analytical queries is finding data within a certain interval of the current date or time. Although the dates in our data are in the past, you will often work with tables that have data being updated daily or even with data streaming in.

Instructions

100 XP

Complete the query to find the difference in days from the current day for the first five orders using the DATE_DIFF() function.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise