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
)
select 
    ITEM_CODE as CODE
    , ORDER_QTY as NAME
    , sum(ORDER_QTY) as SUM_QTY
from ORDERS_DTL
inner join ords on ORDERS_DTL.order_no=ords.order_no
group by ITEM_CODE
having sum(ORDER_QTY)>=50
order by SUM_QTY desc, CODE desc
;