A customer is churned if their last order was more than 120 days before 2024-12-31. List name, last_order and days_inactive for churned customers, longest inactive first.
8 rows with columns name, last_order, days_inactive — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Rohit Nair | 2024-02-28 | 307 |
| 2 | Saanvi Iyer | 2024-04-02 | 273 |
| 3 | Arjun Das | 2024-05-05 | 240 |
Run your code to see the output here.