Exercise

Formatting dates for reports

Using dates and timestamps effectively in BigQuery is a core skill, especially when working with long datasets with multiple entries. This exercise will walk through several ways to query a timestamp from our orders dataset.

Instructions 1/3

undefined XP

1
- Complete the query to find all the orders on September 15th, 2016. The date string should be in the 'YYYY-MM-DD' format.

2
- Find all the orders placed in September by completing the query and counting the order_id.
3
- Find all the orders in the fourth QUARTER of 2017 using a count of the order_id column.

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

Instructions 1/3

Exercise