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

Store (Customers/Orders/Products)

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems