with 
urawa_souko as (
select WH_CODE
from WAREHOUSE
where WH_NAME='浦和倉庫'
), 
ords as (
select order_no
from orders
inner join urawa_souko on orders.wh_code=urawa_souko.wh_code
),
dtl as (
select ITEM_CODE, ORDER_QTY
from ORDERS_DTL
inner join ords on ORDERS_DTL.order_no=ords.order_no
)
select 
    dtl.ITEM_CODE as CODE
    , ITEM_NAME as NAME
    , sum(ORDER_QTY) as SUM_QTY
from dtl
left join ITEM on dtl.ITEM_CODE=ITEM.ITEM_CODE
group by dtl.ITEM_CODE
having sum(ORDER_QTY)>=50
order by SUM_QTY desc, CODE desc
;