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.

Bu egzersiz

Introduction to BigQuery

kursunun bir parçasıdır

Kursu Görüntüle

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- 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'), ___ ___ ___)

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