select 
  i.ITEM_CODE CODE,
  i.ITEM_NAME NAME,
  sum(o.unitprice * o.order_qty) TOTAL_AMT
from orders_dtl o
left join item i using(item_code)
group by 1,2
order by 3 desc, 1 desc