SELECT T2.ITEM_CODE AS CODE
    ,T2.ITEM_NAME AS NAME
    ,SUM(T2.ORDER_QTY) AS SUM_QTY
FROM (SELECT ORDER_NO 
FROM ORDERS AS O
INNER JOIN WAREHOUSE AS W
ON O.WH_CODE = W.WH_CODE
AND W.WH_NAME = '浦和倉庫') AS T1
INNER JOIN (SELECT OD.ITEM_CODE 
    ,OD.ORDER_QTY
    ,I.ITEM_NAME
    FROM ORDERS_DTL AS OD
    LEFT JOIN ITEM AS I
    ON OD.ITEM_CODE = I.ITEM_CODE) AS T2
GROUP BY ITEM_NAME
ORDER BY SUM_QTY DESC
,T2.ITEM_CODE DESC