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.

Deze oefening maakt deel uit van de cursus

Introduction to BigQuery

Cursus bekijken

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- Fill in the query to find the total number of orders in the seven days after Black Friday

SELECT
	COUNT(order_id)
FROM 
	ecommerce.ecomm_order_details
WHERE order_purchase_timestamp BETWEEN
	-- Add the correct date part and interval 
	TIMESTAMP('2017-11-24') AND TIMESTAMP_ADD(TIMESTAMP('2017-11-24'), ___ ___ ___)

Code bewerken en uitvoeren