By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 14 Duplicates: 0 Warnings: 0
| column1 | column2 | timeStamp |
|---|---|---|
| abc | enrolled | 2022-09-01 00:00:00 |
| abc | changed | 2022-09-02 00:00:00 |
| abc | registered | 2022-09-04 00:00:00 |
| abc | blocked | 2022-09-05 00:00:00 |
| abc | left | 2022-09-06 00:00:00 |
| def | enrolled | 2022-09-20 00:00:00 |
| def | changed | 2022-09-21 00:00:00 |
| def | changed | 2022-09-21 00:00:00 |
| def | changed | 2022-09-24 00:00:00 |
| def | left | 2022-09-25 00:00:00 |
| ghi | registered | 2022-09-01 00:00:00 |
| ghi | changed | 2022-09-02 00:00:00 |
| ghi | left | 2022-09-03 00:00:00 |
| ghi | returned | 2022-10-03 00:00:00 |
| out_column1 | out_column2 |
|---|---|
| abc | enrolled-changed-registered-blocked-left |
| def | enrolled-changed-changed-changed-left |
| ghi | registered-changed-left-returned |