MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE operations (
    id int auto_increment primary key,
    orderID VARCHAR(255),
    itemID VARCHAR(255),
    event_date DATE,
    order_volume INT,
    shipped_volume INT
);

INSERT INTO operations
(itemID, orderID, event_date, order_volume, shipped_volume
)
VALUES 
("Item_01", "Order_XYZ", "2020-05-01", "600", "0"),
("Item_01", "Order_XYZ", "2020-05-18", "0", "315"),
("Item_01", "Order_XYZ", "2020-05-19", "0", "100"),
("Item_01", "Order_MTE", "2020-08-15", "400", "0"),
("Item_01", "Order_OBD", "2020-08-21", "500", "0"),
("Item_01", "Order_OBD", "2020-11-17", "0", "380"),

("Item_02", "Order_TLP", "2020-02-02", "500", "0"),
("Item_02", "Order_TLP", "2020-02-10", "0", "175"),
("Item_02", "Order_ADF", "2020-03-27", "100", "0"),

("Item_03", "Order_BBI", "2020-03-12", "700", "0"),

("Item_04", "Order_DXR", "2020-12-09", "260", "0"),
("Item_04", "Order_DXR", "2020-12-15", "0", "110"),
("Item_04", "Order_DXR", "2020-12-15", "0", "60"),
("Item_04", "Order_DXR", "2020-12-15", "0", "80");
SELECT 
itemID,
orderID,
sum(order_volume),
sum(shipped_volume)
FROM operations
WHERE shipped_volume > 0
GROUP BY 1,2;


itemID
orderID
sum(order_volume)
sum(shipped_volume)


Item_01
Order_OBD
0
380

Item_01
Order_XYZ
0
415

Item_02
Order_TLP
0
175

Item_04
Order_DXR
0
250


SELECT 
itemID,
orderID,
sum(order_volume),
sum(shipped_volume)
FROM operations
GROUP BY 1,2
HAVING sum(shipped_volume) > 0;


itemID
orderID
sum(order_volume)
sum(shipped_volume)


Item_01
Order_OBD
500
380

Item_01
Order_XYZ
600
415

Item_02
Order_TLP
500
175

Item_04
Order_DXR
260
250

itemID	orderID	sum(shipped_volume)
Item_01	Order_OBD	380
Item_01	Order_XYZ	415
Item_02	Order_TLP	175
Item_04	Order_DXR	250