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