with urawa as(
    select ORDER_NO
    from ORDERS
    inner join WAREHOUSE
    on WAREHOUSE.WH_CODE = ORDERS.WH_CODE
    where WAREHOUSE.WH_NAME = '浦和倉庫'
) 

select
ORDERS_DTL.ITEM_CODE as CODE,
ITEM.ITEM_NAME as NAME,
sum(ORDERS_DTL.ORDER_QTY) as SUM_QTY

from ORDERS_DTL
inner join urawa
on ORDERS_DTL.ORDER_NO = urawa.ORDER_NO
left join ITEM
on ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE

group by ORDERS_DTL.ITEM_CODE

having sum(ORDERS_DTL.ORDER_QTY) >= 50

order BY
SUM_QTY desc,
CODE desc