SELECT
    D.ITEM_CODE AS CODE,
    CASE
        WHEN D.ITEM_NAME IS NULL THEN 'NULL'
        ELSE D.ITEM_NAME
    END AS NAME,
    SUM(D.ORDER_QTY) AS SUM_QTY
FROM
    ORDERS AS O
LEFT OUTER JOIN
    WAREHOUSE AS W ON O.WH_CODE = W.WH_CODE,
    (
        SELECT
            *
        FROM
            ORDERS_DTL
        INNER JOIN
            ITEM AS I ON ORDERS_DTL.ITEM_CODE = I.ITEM_CODE
    ) AS D ON D.ORDER_NO = O.ORDER_NO
WHERE
    W.WH_NAME = '浦和倉庫'
GROUP BY
    D.ITEM_CODE,
    D.ITEM_NAME
ORDER BY
    SUM_QTY DESC,
    CODE DESC
;