with d as
(
    select o.order_no
    from orders o
    inner join warehouse wh
    on
    o.wh_code = wh.wh_code
    where wh.wh_name = '浦和倉庫'
), agg as (
select
     i.item_code CODE
    ,sum(dtl.order_qty) SUM_QTY
from
    orders_dtl dtl
inner join
    item i
on
    dtl.item_code = i.item_code
inner join d
on
    dtl.order_no = d.order_no
group by i.item_code
having sum(dtl.order_qty) >= 50
)
select
     agg.code CODE
    ,item.item_name NAME
    ,agg.SUM_QTY SUM_QTY
from item
inner join agg
on item.item_code = agg.code
order by 3 desc, 1 desc