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