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