By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | start_date | finish_date | total_value |
---|---|---|---|
1 | 2020-02-03 | 2020-02-05 | 1000.00 |
2 | 2020-02-13 | 2020-02-17 | 1000.00 |
id | single_date | day_value |
---|---|---|
1 | 2020-02-03 | 333.3333333333333 |
1 | 2020-02-04 | 333.3333333333333 |
1 | 2020-02-05 | 333.3333333333333 |
2 | 2020-02-13 | 200.0000000000000 |
2 | 2020-02-14 | 200.0000000000000 |
2 | 2020-02-15 | 200.0000000000000 |
2 | 2020-02-16 | 200.0000000000000 |
2 | 2020-02-17 | 200.0000000000000 |