select
        t3.ItEM_CODE as CODE
    ,   t4.ITEM_NAME as NAME
    ,    SUM(t3.ORDER_QTY) as SUM_QTY
from
    ORDERS as t1
left join
    WAREHOUSE as t2
on
    t1.WH_CODE = t2.WH_CODE
left join
    ORDERS_DTL as t3
on
    t1.ORDER_NO = t3.ORDER_NO
left join
    ITEM as t4
on
    t3.ITEM_CODE = t4.ITEM_CODE
where
    t2.WH_CODE = 100
group by
    t3.ITEM_CODE
order by
    SUM_QTY desc, CODE desc