By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| appeal_id | client_id | dt | text |
|---|---|---|---|
| 1 | 111 | 2022-03-14 15:11:45.000 | Обращение |
| 2 | 111 | 2022-03-14 15:12:51.000 | Отказ |
| 8 | 111 | 2022-03-14 15:16:22.000 | Обращение |
| 9 | 111 | 2022-03-14 15:17:36.000 | Отказ |
| 4 | 111 | 2022-03-14 15:18:36.000 | Нет документов |
| 5 | 111 | 2022-03-31 13:30:05.000 | Обращение |
| 3 | 111 | 2022-03-31 13:30:54.000 | Отказ |
| 10 | 111 | 2022-03-31 13:32:47.000 | Обращение |
| 11 | 111 | 2022-03-31 13:33:47.000 | Одобрено |
| 6 | 111 | 2022-03-31 13:34:28.000 | Есть документы |
| 7 | 111 | 2022-04-01 00:00:00.000 | Проведено |
| client_id | Обращение | Отказ | Одобрено | Проведено | Нет документов | Есть документы |
|---|---|---|---|---|---|---|
| 111 | 2022-03-14 15:11:45.000 | 2022-03-14 15:12:51.000 | null | null | null | null |
| 111 | 2022-03-14 15:16:22.000 | 2022-03-14 15:17:36.000 | null | null | 2022-03-14 15:18:36.000 | null |
| 111 | 2022-03-31 13:30:05.000 | 2022-03-31 13:30:54.000 | null | null | null | null |
| 111 | 2022-03-31 13:32:47.000 | null | 2022-03-31 13:33:47.000 | 2022-04-01 00:00:00.000 | null | 2022-03-31 13:34:28.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.