SELECT
    OD.ITEM_CODE AS CODE
    ,I.ITEM_NAME AS NAME
    ,SUM(OD.ORDER_QTY) AS SUM_QTY --??

FROM
    ORDERS O
    INNER JOIN 
        ORDERS_DTL OD
    ON O.ORDER_NO = OD.ORDER_NO
    LEFT JOIN --商品データ(ITEM)に該当の商品コードが存在しない場合は、商品名称は非表示(NULL)
        ITEM I
    ON OD.ITEM_CODE = I.ITEM_CODE

WHERE
    O.WH_CODE IN (SELECT 
                    WH_CODE
                  FROM
                    WAREHOUSE
                  WHERE
                    WH_NAME = '浦和倉庫'
                    )
    
GROUP BY
    CODE,NAME
HAVING
    SUM_QTY >= 50
ORDER BY
    SUM_QTY DESC
    ,CODE DESC