select
    od.ITEM_CODE as CODE
    ,i.ITEM_NAME as NAME
    ,SUM(od.ORDER_QTY) as SUM_QTY 
from
    WAREHOUSE w 
    INNER JOIN ORDERS o 
        on o.WH_CODE = w.WH_CODE 
    INNER JOIN ORDERS_DTL od
        on od.ORDER_NO = o.ORDER_NO 
    LEFT JOIN ITEM i
        on i.ITEM_CODE = od.ITEM_CODE
WHERE
    w.WH_NAME = '浦和倉庫' 
group by
    od.ITEM_CODE,
    i.ITEM_NAME
having
    SUM_QTY >= 50
order by
    SUM_QTY DESC
    ,CODE DESC
;