By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| patients | no_pats | Dates |
|---|---|---|
| null | 0 | 2022-05-01 05:00:00.000 |
| null | 0 | 2022-05-01 06:00:00.000 |
| null | 0 | 2022-05-01 07:00:00.000 |
| null | 0 | 2022-05-01 08:00:00.000 |
| 1 | 1 | 2022-05-01 09:00:00.000 |
| 1 | 1 | 2022-05-01 10:00:00.000 |
| 1,2 | 2 | 2022-05-01 11:00:00.000 |
| 1,2,3 | 3 | 2022-05-01 12:00:00.000 |
| 1,2,3 | 3 | 2022-05-01 13:00:00.000 |
| 1,2,3 | 3 | 2022-05-01 14:00:00.000 |
| 1,3 | 2 | 2022-05-01 15:00:00.000 |
| 1,3 | 2 | 2022-05-01 16:00:00.000 |
| 1,3 | 2 | 2022-05-01 17:00:00.000 |
| 1,3 | 2 | 2022-05-01 18:00:00.000 |
| 3 | 1 | 2022-05-01 19:00:00.000 |
| 3 | 1 | 2022-05-01 20:00:00.000 |
| 3 | 1 | 2022-05-01 21:00:00.000 |
| 3 | 1 | 2022-05-01 22:00:00.000 |
| 3 | 1 | 2022-05-01 23:00:00.000 |
| 3 | 1 | 2022-05-02 00:00:00.000 |
| 3 | 1 | 2022-05-02 01:00:00.000 |
| 3 | 1 | 2022-05-02 02:00:00.000 |
| 3 | 1 | 2022-05-02 03:00:00.000 |
| 3 | 1 | 2022-05-02 04:00:00.000 |
| 3 | 1 | 2022-05-02 05:00:00.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.