with tbl_order as(
    select * 
    from ORDERS
    left join WAREHOUSE
        on ORDERS.WH_CODE = WAREHOUSE.WH_CODE 
    where WAREHOUSE.WH_NAME = '浦和倉庫'
)
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
order by
    SUM_QTY desc
    ,CODE desc