medium10 pts · first answer countswindow-functionssqlcustomer-analytics

Spotting customers who lapsed

A customer counts as lapsed if they go more than 90 days without ordering. Which expression helps flag each order that was followed by a lapse?

A.LEAD(order_date) per customer minus order_date > 90B.LAG(order_date) per customer minus order_date > 90C.MAX(order_date) minus MIN(order_date) per customer > 90D.COUNT(*) per customer within 90 days of the first order

Discussion 0

Join free to post in the discussion.

Spotting customers who lapsed

Discussion 0

Related questions