select
    d.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    sum(d.ORDER_QTY) as SUM_QTY
from ORDERS o
    inner join ORDERS_DTL d
        on d.ORDER_NO = o.ORDER_NO
    left outer join ITEM i
        on i.ITEM_CODE = d.ITEM_CODE
where
    o.WH_CODE = (
        select WH_CODE
        from WAREHOUSE
        where WH_NAME = '浦和倉庫'
    )
group by
    d.ITEM_CODE,
    i.ITEM_NAME
having
    sum(d.ORDER_QTY) >= 50
order by
    SUM_QTY desc,
    d.ITEM_CODE desc;