with tmp1 as (
    select order_no 
    from orders 
    inner join warehouse 
    on orders.wh_code=warehouse.wh_code 
    where wh_name="浦和倉庫"
),
tmp2 as (
select 
orders_dtl.item_code as CODE,
sum(ORDER_QTY) as SUM_QTY
from tmp1 
inner join orders_dtl 
on tmp1.order_no=orders_dtl.order_no 
group by orders_dtl.item_code 
having sum(ORDER_QTY)>=50 
order by sum_qty desc,code desc 
)
select 
CODE,
item_name as NAME,
SUM_QTY
from tmp2 
left outer join item
on tmp2.code=item.item_code