select
ORDERS_DTL.ITEM_CODE as 'CODE',
ITEM.ITEM_NAME as 'NAME',
ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY as 'TOTAL_AMT'
from ORDERS_DTL
inner join ITEM
on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE 
order by TOTAL_AMT desc, ORDERS_DTL.ITEM_CODE desc