Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Churned customers
4. Churned customers in weekly cohorts – exercise
Customer retention charts
Summary

Instruction

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

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