Subscription Churn Candidates

As of 2025-06-01, flag active subscriptions whose renewal_date is within 14 days inclusive and whose latest qualifying product activity is at least 30 full days old. login and feature_use qualify. Cancelled subscriptions never qualify. Return account_id, renewal_date, last_activity_at and inactive_days. Return columns: account_id, renewal_date, last_activity_at, inactive_days.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

As of 2025-06-01, flag active subscriptions whose renewal_date is within 14 days inclusive and whose latest qualifying product activity is at least 30 full days old. login and feature_use qualify. Cancelled subscriptions never qualify. Return account_id, renewal_date, last_activity_at and inactive_days. Return columns: account_id, renewal_date, last_activity_at, inactive_days.

Difficulty: Advanced
SQL concept: CTE