SELECT
    WK.CODE
    ,WK.NAME
    ,WK.SUM_QTY
FROM (
    SELECT
        C.ITEM_CODE AS CODE
        ,D.ITEM_NAME AS NAME
        ,SUM(C.ORDER_QTY) AS SUM_QTY
    FROM WAREHOUSE A
    INNER JOIN ORDERS B
    ON A.WH_CODE = B.WH_CODE
    AND A.WH_NAME = '浦和倉庫'
    INNER JOIN ORDERS_DTL C
    ON B.ORDER_NO = C.ORDER_NO
    LEFT JOIN ITEM D
    ON C.ITEM_CODE = D.ITEM_CODE
    GROUP BY C.ITEM_CODE
) WK
WHERE WK.SUM_QTY >= 50
ORDER BY
    WK.SUM_QTY DESC
    ,WK.CODE DESC
;