WITH a AS(
    SELECT
        ORDERS_DTL.ITEM_CODE  AS CODE
        , ITEM_NAME AS NAME
        , SUM(ORDER_QTY) AS SUM_QTY
    FROM
        ORDERS
        INNER JOIN WAREHOUSE 
            ON WAREHOUSE.WH_NAME = '浦和倉庫'
            AND ORDERS.WH_CODE = WAREHOUSE.WH_CODE
        INNER JOIN ORDERS_DTL USING(ORDER_NO)
        LEFT OUTER JOIN ITEM USING(ITEM_CODE)
    GROUP BY 1,2
)
SELECT
    CODE
    , NAME
    , SUM_QTY
FROM
    a
WHERE SUM_QTY >= 50
ORDER BY 3 DESC, 1 DESC;