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.30
Records: 19  Duplicates: 0  Warnings: 0
Order No. Tot/day/order Avg/day/order
1 300 100
2 375 125
3 1400 200
4 300 50
COUNT(order_no)
3
3
7
6
Order No. Start Date End Date Total/order Avg/day/order No. of deliveries Tot sales
1 2021-01-14 10:00:00 2021-01-16 10:00:00 100 100 3 2375
2 2021-01-14 10:00:00 2021-01-16 10:00:00 125 125 3 2375
3 2021-01-17 10:00:00 2021-01-23 10:00:00 200 200 7 2375
4 2021-01-14 10:00:00 2021-01-19 10:00:00 50 50 6 2375
Records: 17  Duplicates: 0  Warnings: 0
the_sum dat
275 2021-01-14 10:00:00
275 2021-01-15 10:00:00
275 2021-01-16 10:00:00
250 2021-01-17 10:00:00
250 2021-01-18 10:00:00
250 2021-01-19 10:00:00
200 2021-01-20 10:00:00
200 2021-01-21 10:00:00
200 2021-01-22 10:00:00
200 2021-01-23 10:00:00
The date: No. delivered
2021-01-12 0
2021-01-13 0
2021-01-14 275
2021-01-15 275
2021-01-16 275
2021-01-17 250
2021-01-18 250
2021-01-19 250
2021-01-20 200
2021-01-21 200
2021-01-22 200
2021-01-23 200
2021-01-24 0
2021-01-25 0
2021-01-26 0
2021-01-27 0
2021-01-28 0