SELECT
    ODD.ITEM_CODE AS CODE
    , IT.ITEM_NAME AS NAME
    -- SUM関数で受注数量を集計する
    , SUM(ODD.ORDER_QTY) AS SUM_QTY 
    
FROM
    WAREHOUSE AS WH
    
    INNER JOIN ORDERS AS OD
        ON OD.WH_CODE = WH.WH_CODE
    
    INNER JOIN ORDERS_DTL AS ODD
        ON ODD.ORDER_NO = OD.ORDER_NO
    
    LEFT OUTER JOIN ITEM AS IT
        ON IT.ITEM_CODE = ODD.ITEM_CODE

WHERE
    WH.WH_NAME LIKE '浦和倉庫'
    
GROUP BY
    ODD.ITEM_CODE
HAVING
    SUM_QTY >= 50
ORDER BY
    SUM_QTY DESC,
    CODE DESC
;