Finding the last 90 days of orders
The report you have been asked to create asks for orders older than 90 days from the current date. You will implement what you have learned so far into the report query.
Questo esercizio fa parte del corso
Introduction to BigQuery
Istruzioni dell'esercizio
- In the
WHEREclause, find the date that is 90 days in the past to pass as an argument to theTIMESTAMP_SUB()function. - Then filter the results where the column
order_purchase_timestampis less than that value.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT order_id, order_purchase_timestamp
FROM ecommerce.ecomm_order_details
-- Filter results for orders older than 90 days old
WHERE ___ <= ___(CURRENT_TIMESTAMP(), INTERVAL ___ ___)