add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
8.0.23
id quantity dt_start dt_END
1 100 2021-01-14 10:00:00 2021-01-16 10:00:00
2 125 2021-01-14 10:00:00 2021-01-16 10:00:00
4 50 2021-01-14 10:00:00 2021-01-19 10:00:00
7 100 2021-01-16 10:00:00 2021-01-19 10:00:00
8 200 2021-01-16 10:00:00 2021-01-19 10:00:00
6 75 2021-01-16 10:00:00 2021-01-21 10:00:00
3 200 2021-01-17 10:00:00 2021-01-23 10:00:00
9 50 2021-01-18 10:00:00 2021-01-19 10:00:00
5 100 2021-01-21 10:00:00 2021-01-23 10:00:00
10 150 2021-01-21 10:00:00 2021-01-23 10:00:00
the_sum period
275 per_1
625 per_2
250 per_3
the_sum period
625 per_2