select 
-- *
item.ITEM_CODE as CODE,
item.ITEM_NAME as NAME,
sum(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT


from item

inner join ORDERS_DTL
on item.item_code = ORDERS_DTL.item_code

group by item.item_code

order by TOTAL_AMT desc, item.item_code desc
;