WITH S1 AS (
    SELECT
        ORDER_NO,
        ITEM_CODE
    FROM
        ORDERS_DTL
    GROUP BY
        ORDER_NO, ITEM_CODE
)

SELECT
    OD.ITEM_CODE AS CODE,
    IT.ITEM_NAME AS NAME,
    OD.TOTAL AS SUM_QTY
FROM
    ORDERS OH
    INNER JOIN WAREHOUSE WH ON OH.WH_CODE = WH.WH_CODE
    INNER JOIN S1 ON OH.ORDER_NO = S1.ORDER_NO
    INNER JOIN 
    (
        SELECT
            ITEM_CODE,
            SUM(ORDER_QTY) AS TOTAL
        FROM
            ORDERS_DTL
        GROUP BY
            ITEM_CODE
        HAVING
            TOTAL >= 50
    ) OD ON S1.ITEM_CODE = OD.ITEM_CODE
    LEFT JOIN ITEM IT ON OD.ITEM_CODE = IT.ITEM_CODE
WHERE
    WH.WH_NAME = '浦和倉庫'
ORDER BY
    SUM_QTY DESC, CODE DESC