By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
itemID | orderID | sum(order_volume) | sum(shipped_volume) | position |
---|---|---|---|---|
Item_04 | Order_DXR | 260 | 110 | 1 |
Item_03 | Order_BBI | 700 | 280 | 1 |
Item_02 | Order_ZGO | 375 | 120 | 1 |
Item_02 | Order_TLP | 500 | 175 | 1 |
Item_02 | Order_SNE | 900 | 620 | 1 |
Item_02 | Order_ADF | 100 | 30 | 1 |
Item_01 | Order_XYZ | 600 | 315 | 1 |
Item_01 | Order_OBD | 500 | 380 | 1 |
Item_01 | Order_MTE | 400 | 120 | 1 |