By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE
CREATE TABLE
INSERT 0 7
| id | users | dates |
|---|---|---|
| 1 | 1ab7 | 2022-01-04 10:22:00 |
| 2 | 1ab7 | 2022-04-26 18:30:00 |
| 3 | 1ab7 | 2022-05-12 20:10:00 |
| 4 | 1ab7 | 2022-07-02 20:55:00 |
| 5 | 3ac5 | 2022-02-05 05:12:00 |
| 6 | 3ac5 | 2022-04-09 07:17:00 |
| 7 | 3ac5 | 2022-07-03 04:19:00 |
SELECT 7
| users | dates | status |
|---|---|---|
| 1ab7 | 2022-01-04 10:22:00 | first_purchase |
| 1ab7 | 2022-02-01 00:00:00 | churn |
| 1ab7 | 2022-03-01 00:00:00 | churn |
| 1ab7 | 2022-04-26 18:30:00 | retained |
| 1ab7 | 2022-05-12 20:10:00 | retained |
| 1ab7 | 2022-06-01 00:00:00 | churn |
| 1ab7 | 2022-07-02 20:55:00 | retained |
| 1ab7 | 2022-08-01 00:00:00 | churn |
| 1ab7 | 2022-09-01 00:00:00 | churn |
| 1ab7 | 2022-10-01 00:00:00 | churn |
| 1ab7 | 2022-11-01 00:00:00 | churn |
| 1ab7 | 2022-12-01 00:00:00 | churn |
| 1ab7 | 2023-01-01 00:00:00 | churn |
| 3ac5 | 2022-02-05 05:12:00 | first_purchase |
| 3ac5 | 2022-03-01 00:00:00 | churn |
| 3ac5 | 2022-04-09 07:17:00 | retained |
| 3ac5 | 2022-05-01 00:00:00 | churn |
| 3ac5 | 2022-06-01 00:00:00 | churn |
| 3ac5 | 2022-07-03 04:19:00 | retained |
| 3ac5 | 2022-08-01 00:00:00 | churn |
| 3ac5 | 2022-09-01 00:00:00 | churn |
| 3ac5 | 2022-10-01 00:00:00 | churn |
| 3ac5 | 2022-11-01 00:00:00 | churn |
| 3ac5 | 2022-12-01 00:00:00 | churn |
| 3ac5 | 2023-01-01 00:00:00 | churn |
SELECT 25