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 |