mediumCelcomDigi · subqueryPro
Inactive subscribers
CelcomDigi wants to flag subscribers at risk of churning.
From the subscribers table, return the name of every subscriber whose last_active is more than 90 days before the most recent last_active across all subscribers.
Schema
▸subscribers
| id | INT |
| name | TEXT |
| last_active | DATE |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.