By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| VacationID | VacationDate | day_dur | rest |
|---|---|---|---|
| 1 | 24/01/2018 00:00:00 | 4 | 0 |
| 2 | 21/03/2018 00:00:00 | 24 | 16 |
| 3 | 16/08/2018 00:00:00 | 24 | 9 |
| 4 | 01/12/2018 00:00:00 | 8 | 0 |
| 5 | 17/12/2018 00:00:00 | 24 | 32 |
| 6 | 17/12/2018 00:00:00 | 24 | 0 |
| 5 | 18/12/2018 00:00:00 | 24 | 8 |
| 5 | 19/12/2018 00:00:00 | 8 | 0 |
| 3 | 17/08/2018 00:00:00 | 9 | 0 |
| 2 | 22/03/2018 00:00:00 | 16 | 0 |