This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Retention Analyst at T-Mobile. To segment customers by loyalty and predict churn risk, you need to know how long each active subscription has been running. Since this dataset is a static snapshot, use the maximum due_date from the bills table as a proxy for "today" and compute the tenure in whole days from each subscription's start_date.
You are a Retention Analyst at T-Mobile. To segment customers by loyalty and predict churn risk, you need to know how long each active subscription has been running. Since this dataset is a static snapshot, use the maximum due_date from the bills table as a proxy for "today" and compute the tenure in whole days from each subscription's start_date.