Skip to content
SQLSimplified
hardstorewindowlag

Customer Order Date Gaps

Problem

Return customer_id, order_date, and days_since_prev (days since that customer's previous order) ordered by customer_id then order_date.

Try It

Loading playground environment...

Hint

Solution

Next Problem