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