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_MTE", "2020-08-15", "400", "0"),
("Item_01", "Order_MTE", "2020-08-23", "0", "120"),
("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_SNE", "2020-02-03", "900", "0"),
("Item_02", "Order_SNE", "2020-03-18", "0", "620"),
("Item_02", "Order_ADF", "2020-03-27", "100", "0"),
("Item_02", "Order_ADF", "2020-03-28", "0", "30"),
("Item_02", "Order_ZGO", "2020-04-15", "375", "0"),
("Item_02", "Order_ZGO", "2020-04-17", "0", "120"),

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

("Item_04", "Order_DXR", "2020-12-09", "260", "0"),
("Item_04", "Order_DXR", "2020-12-15", "0", "110");

itemID	orderID	order_volume	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_ADF	100	30	2
Item_02	Order_SNE	900	620	3
Item_02	Order_TLP	500	175	4
Item_01	Order_OBD	500	380	1
Item_01	Order_MTE	400	120	2
Item_01	Order_XYZ	600	315	3