By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | Category | DateFrom | DateTo | ExpectedResult |
|---|---|---|---|---|
| 1 | 1 | 01/03/2019 00:00:00 | 06/03/2019 00:00:00 | 7 |
| 2 | 1 | 08/03/2019 00:00:00 | 09/03/2019 00:00:00 | 3 |
| 3 | 1 | 11/03/2019 00:00:00 | 14/03/2019 00:00:00 | 3 |
| 1 | 2 | 04/03/2019 00:00:00 | 07/03/2019 00:00:00 | 4 |
| 2 | 2 | 08/03/2019 00:00:00 | 15/03/2019 00:00:00 | 10 |
| 3 | 2 | 18/03/2019 00:00:00 | 24/03/2019 00:00:00 | 6 |
| id | category | datefrom | dateto | expectedresult | calculatedexpectedresult |
|---|---|---|---|---|---|
| 1 | 1 | 01/03/2019 00:00:00 | 06/03/2019 00:00:00 | 7 | 7 |
| 2 | 1 | 08/03/2019 00:00:00 | 09/03/2019 00:00:00 | 3 | 3 |
| 3 | 1 | 11/03/2019 00:00:00 | 14/03/2019 00:00:00 | 3 | 3 |
| 1 | 2 | 04/03/2019 00:00:00 | 07/03/2019 00:00:00 | 4 | 4 |
| 2 | 2 | 08/03/2019 00:00:00 | 15/03/2019 00:00:00 | 10 | 10 |
| 3 | 2 | 18/03/2019 00:00:00 | 24/03/2019 00:00:00 | 6 | 6 |