By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ts | customer_id | event | desired_result |
|---|---|---|---|
| 2021-10-12 05:00:00 | 111 | 1 | 2021-10-12 05:00:00 |
| 2021-10-12 08:00:00 | 111 | 2 | 2021-10-12 05:00:00 |
| 2021-10-12 11:00:00 | 111 | 2 | 2021-10-12 05:00:00 |
| 2021-10-12 14:00:00 | 111 | 3 | 2021-10-12 05:00:00 |
| 2021-10-12 17:00:00 | 111 | 1 | 2021-10-12 17:00:00 |
| 2021-10-12 20:00:00 | 111 | 1 | 2021-10-12 20:00:00 |
| 2021-10-12 23:00:00 | 111 | 3 | 2021-10-12 20:00:00 |
| 2021-11-12 02:00:00 | 111 | 4 | 2021-10-12 20:00:00 |
| 2021-11-12 05:00:00 | 111 | 2 | 2021-10-12 20:00:00 |
| 2021-11-12 08:00:00 | 111 | 1 | 2021-11-12 08:00:00 |
| 2021-11-12 11:00:00 | 111 | 2 | 2021-11-12 08:00:00 |
Warning: Null value is eliminated by an aggregate or other SET operation.