WITH urawa AS(
    SELECT
        *
    FROM
        ORDERS
    WHERE
        WH_CODE = (
            SELECT
                WH_CODE AS 'CODE'
            FROM
                WAREHOUSE
            WHERE
                WH_NAME = '浦和倉庫'
        )
),
res AS(
    SELECT
        ITEM_CODE AS 'CODE',
        SUM(ORDER_QTY) AS 'QTY'
    FROM
        ORDERS_DTL
        JOIN urawa ON ORDERS_DTL.ORDER_NO = urawa.ORDER_NO
    GROUP BY
        ITEM_CODE
)
SELECT
    CODE,
    ITEM_NAME AS 'NAME',
    QTY AS 'SUM_QTY'
FROM
    res
    LEFT JOIN ITEM ON res.CODE = ITEM.ITEM_CODE
WHERE
    res.QTY >= 50
ORDER BY
    QTY DESC,
    CODE DESC