Exercise

Finding data within certain ranges

Finding results within a certain range of a specific date (e.g., Black Friday for e-commerce) or between two dates is another common analytical query. This exercise will walk through a few different scenarios like these.

Instructions 1/3

undefined XP

1
- Complete the query to find the total number of orders seven days after Black Friday in 2017. The first keyword is INTERVAL.

2
- Complete the query to find all orders 30 days before Black Friday using the order_purchase_timestamp column and a function ending in _SUB.
3
- Find the total orders three days before and after Black Friday 2017 using the order_purchase_timestamp column.

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

Instructions 1/3

Exercise