By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| event_id | customer_id | status | created_at | resolved_atT | first_failed_atT |
|---|---|---|---|---|---|
| e7921c9c-aa8f-49bb-83fa-31fa37d629ee | a | completed | 2024-01-16 16:23:31.000 | null | null |
| 1d6a5bdf-e254-441d-9574-821844dc6c05 | a | failed | 2024-01-17 19:17:33.000 | null | 2024-01-17 19:17:33.000 |
| 1a06783a-2ca4-4f68-80f0-7e7c84ac57fd | a | failed | 2024-01-22 18:07:54.000 | null | 2024-01-17 19:17:33.000 |
| 61ecc8da-1e7f-4b19-92f1-fda93661a3af | a | failed | 2024-01-23 17:54:12.000 | 2024-01-24 19:34:48.000 | 2024-01-17 19:17:33.000 |
| 068e4220-bd57-410a-85f3-1fbb18f86053 | a | completed | 2024-01-24 19:34:48.000 | null | null |
| 4ad30d16-ff13-48f3-b315-8a588d869c08 | a | completed | 2024-01-25 17:30:54.000 | null | null |
| 82f8c57a-0e80-4ea6-96ad-3b578e5ec68a | a | failed | 2024-01-27 17:45:11.000 | null | 2024-01-27 17:45:11.000 |
| 17d736d6-40de-4440-a220-e4a0612acb71 | a | failed | 2024-01-28 17:51:15.000 | 2024-01-29 17:23:31.000 | 2024-01-27 17:45:11.000 |
| be657472-69d0-4cd5-82e0-b33434ff213a | a | completed | 2024-01-29 17:23:31.000 | null | null |
| 3bce3901-2639-489d-8280-04518a253b33 | b | failed | 2023-12-15 15:06:32.000 | null | 2023-12-15 15:06:32.000 |
| 99b1bd8b-0ac3-4868-b687-73fc93ef9ddf | b | failed | 2023-12-16 15:07:21.000 | 2023-12-17 15:10:42.000 | 2023-12-15 15:06:32.000 |
| 406b42e6-63c6-402e-9519-87240d007315 | b | completed | 2023-12-17 15:10:42.000 | null | null |
| 946e4c25-db5a-44e4-8c29-d7144ff5b03c | c | failed | 2023-12-15 15:06:10.000 | null | 2023-12-15 15:06:10.000 |
| ba0c96d2-4b68-43e5-99a6-0f30530dd1ad | c | failed | 2023-12-16 15:06:32.000 | null | 2023-12-15 15:06:10.000 |
| event_id | customer_id | status | created_at | groupNum | resolved_at | first_failed_at |
|---|---|---|---|---|---|---|
| e7921c9c-aa8f-49bb-83fa-31fa37d629ee | a | completed | 2024-01-16 16:23:31.000 | 0 | 2024-01-16 16:23:31.000 | null |
| 1d6a5bdf-e254-441d-9574-821844dc6c05 | a | failed | 2024-01-17 19:17:33.000 | 1 | 2024-01-24 19:34:48.000 | 2024-01-17 19:17:33.000 |
| 1a06783a-2ca4-4f68-80f0-7e7c84ac57fd | a | failed | 2024-01-22 18:07:54.000 | 1 | 2024-01-24 19:34:48.000 | 2024-01-17 19:17:33.000 |
| 61ecc8da-1e7f-4b19-92f1-fda93661a3af | a | failed | 2024-01-23 17:54:12.000 | 1 | 2024-01-24 19:34:48.000 | 2024-01-17 19:17:33.000 |
| 068e4220-bd57-410a-85f3-1fbb18f86053 | a | completed | 2024-01-24 19:34:48.000 | 1 | 2024-01-24 19:34:48.000 | 2024-01-17 19:17:33.000 |
| 4ad30d16-ff13-48f3-b315-8a588d869c08 | a | completed | 2024-01-25 17:30:54.000 | 2 | 2024-01-25 17:30:54.000 | null |
| 82f8c57a-0e80-4ea6-96ad-3b578e5ec68a | a | failed | 2024-01-27 17:45:11.000 | 3 | 2024-01-29 17:23:31.000 | 2024-01-27 17:45:11.000 |
| 17d736d6-40de-4440-a220-e4a0612acb71 | a | failed | 2024-01-28 17:51:15.000 | 3 | 2024-01-29 17:23:31.000 | 2024-01-27 17:45:11.000 |
| be657472-69d0-4cd5-82e0-b33434ff213a | a | completed | 2024-01-29 17:23:31.000 | 3 | 2024-01-29 17:23:31.000 | 2024-01-27 17:45:11.000 |
| 3bce3901-2639-489d-8280-04518a253b33 | b | failed | 2023-12-15 15:06:32.000 | 0 | 2023-12-17 15:10:42.000 | 2023-12-15 15:06:32.000 |
| 99b1bd8b-0ac3-4868-b687-73fc93ef9ddf | b | failed | 2023-12-16 15:07:21.000 | 0 | 2023-12-17 15:10:42.000 | 2023-12-15 15:06:32.000 |
| 406b42e6-63c6-402e-9519-87240d007315 | b | completed | 2023-12-17 15:10:42.000 | 0 | 2023-12-17 15:10:42.000 | 2023-12-15 15:06:32.000 |
| 946e4c25-db5a-44e4-8c29-d7144ff5b03c | c | failed | 2023-12-15 15:06:10.000 | 0 | null | 2023-12-15 15:06:10.000 |
| ba0c96d2-4b68-43e5-99a6-0f30530dd1ad | c | failed | 2023-12-16 15:06:32.000 | 0 | null | 2023-12-15 15:06:10.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.