with tbl_order as(
    select * 
    from ORDERS
    left join WAREHOUSE
        on ORDERS.WH_CODE = WAREHOUSE.WH_CODE 
    where WAREHOUSE.WH_NAME = '浦和倉庫'
)
,tbl_sum as(
    select
        ORDERS_DTL.ITEM_CODE as CODE
        ,ITEM_NAME as NAME
        ,sum(ORDER_QTY) as SUM_QTY
    from tbl_order
    left join ORDERS_DTL
        on tbl_order.ORDER_NO = ORDERS_DTL.ORDER_NO
    left join ITEM
        on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE 
    group by 
        ORDERS_DTL.ITEM_CODE
        ,ITEM_NAME
)
select * 
from tbl_sum
where SUM_QTY >= 50
    order by
        SUM_QTY desc
        ,CODE desc