WITH S1 AS(
    SELECT
        *
    FROM
        ORDERS t1
        INNER JOIN WAREHOUSE t2 ON t1.WH_CODE = t2.WH_CODE
    WHERE
        t2.WH_NAME = '浦和倉庫'
),
S2 AS (
    SELECT
        ITEM_CODE,
        SUM(ORDER_QTY) AS TOTAL
    FROM
        ORDERS_DTL t3
        INNER JOIN S1 ON t3.ORDER_NO = S1.ORDER_NO
    GROUP BY
        ITEM_CODE
    HAVING
        TOTAL >= 50
)


SELECT
    S2.ITEM_CODE AS CODE,
    IT.ITEM_NAME AS NAME,
    S2.TOTAL AS SUM_QTY
FROM
    S2
    LEFT JOIN ITEM IT ON S2.ITEM_CODE = IT.ITEM_CODE
ORDER BY
    SUM_QTY DESC, CODE DESC