select C.item_code as CODE,C.item_name as NAME,(B.unitprice * B.order_qty) as TOTAL_AMT
from orders as A
inner join orders_dtl as B
on A.order_no = B.order_no
left join item as C
on B.item_code = C.item_code
order by TOTAL_AMT desc, CODE desc;