select 
    OD.ITEM_CODE as CODE
    ,I.ITEM_NAME as NAME
    ,SUM(OD.ORDER_QTY) as SUM_QTY
from
    ORDERS as O
    inner join ORDERS_DTL as OD
        on O.ORDER_NO=OD.ORDER_NO
    left outer join ITEM as I
        on OD.ITEM_CODE=I.ITEM_CODE
where
    WH_CODE = (select WH_CODE from WAREHOUSE where WH_NAME='浦和倉庫')
group by
    OD.ITEM_CODE
order by
    SUM(OD.ORDER_QTY) desc
    ,OD.ITEM_CODE desc
    ;