SELECT
    QTY.CODE
    , ITEM.ITEM_NAME AS NAME
    , QTY.SUM_QTY
FROM
    (
        SELECT
            ORDERS_DTL.ITEM_CODE AS CODE
            , SUM(ORDERS_DTL.ORDER_QTY) AS SUM_QTY
        FROM
            ORDERS
            JOIN
                WAREHOUSE
                ON
                    ORDERS.WH_CODE = WAREHOUSE.WH_CODE
                    AND WAREHOUSE.WH_NAME = "浦和倉庫"
            JOIN
                ORDERS_DTL
                USING (ORDER_NO)
        GROUP BY
            ORDERS_DTL.ITEM_CODE
        HAVING
            SUM(ORDERS_DTL.ORDER_QTY) >= 50
    ) AS QTY
    LEFT JOIN
        ITEM
        ON QTY.CODE = ITEM.ITEM_CODE
ORDER BY
    QTY.SUM_QTY DESC,
    QTY.CODE DESC