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.

Bu egzersiz

Introduction to BigQuery

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

In the WHERE clause, find the date that is 90 days in the past to pass as an argument to the TIMESTAMP_SUB() function.
Then filter the results where the column order_purchase_timestamp is less than that value.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT order_id, order_purchase_timestamp 
FROM ecommerce.ecomm_order_details
-- Filter results for orders older than 90 days old
WHERE ___ <= ___(CURRENT_TIMESTAMP(), INTERVAL ___ ___)

Kodu Düzenle ve Çalıştır