Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Churned customers
4. Churned customers in weekly cohorts – exercise
Customer retention charts


Great job! Now let's do a similar exercise.


Find the number of churned customers in weekly signup cohorts from 2017. In this exercise, churned customers are those who haven't placed an order in 30 days. Show the following columns: Week and ChurnedCustomers. Order the results by week.

Stuck? Here's a hint!

Use the following condition in the WHERE clause:

DATEDIFF(Day, LastOrderDate, GETDATE()) > 30