For every customer, return name, first_order, last_order, orders, lifetime_value (all items, 0 if none) and segment: 'Never ordered', 'One-time' or 'Repeat'.
15 rows with columns name, first_order, last_order, orders, lifetime_value, segment — first 3 shown:
| # | ||||||
|---|---|---|---|---|---|---|
| 1 | Aarav Shah | 2024-01-05 | 2024-10-20 | 4 | 15138 | Repeat |
| 2 | Diya Patel | 2024-01-12 | 2024-07-21 | 2 | 6096 | Repeat |
| 3 | Kabir Singh | 2024-01-20 | 2024-09-08 | 3 | 13497 | Repeat |
Run your code to see the output here.