Level 4 - Mid-LevelQuery-Based Questions
Customers with >30 Day Purchase Gap
Return customer_id and gap_start_date where next purchase is more than 30 days later.
Schema Context
orders(id, customer_id, order_date)
Return customer_id and gap_start_date where next purchase is more than 30 days later.
orders(id, customer_id, order_date)