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.
Este ejercicio forma parte del curso
Introduction to BigQuery
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
-- 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'), ___ ___ ___)