SELECT od.ITEM_CODE AS CODE,i.ITEM_NAME AS NAME,SUM(od.ORDER_QTY) AS SUM_QTY

FROM  ORDERS_DTL AS od

LEFT JOIN ITEM AS i ON od.ITEM_CODE = i.ITEM_CODE
JOIN ORDERS AS o ON od.ORDER_NO = o.ORDER_NO

WHERE o.WH_CODE = 100

GROUP BY od.ITEM_CODE

ORDER BY SUM_QTY DESC,od.ITEM_CODE DESC