Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Customer Behavior Analysis in SQL

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 churned_customers. Order the results by week.

Stuck? Here's a hint!

Use the following condition in the WHERE clause:

CURRENT_DATE - last_order_date > INTERVAL '30' day