select
A.ITEM_CODE as 'CODE',
A.ITEM_NAME as 'NAME',
A.UNITPRICE * A.ORDER_QTY as 'TOTAL_AMT'
from (
select *
from ORDERS_DTL
inner join ITEM
on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE ) A
inner join ORDERS
on ORDERS.ORDER_NO = A.ORDER_NO 
where 
'2023-05-14' <= ORDERS.ORDER_DATE <= '2023-05-20'
order by TOTAL_AMT desc, A.ITEM_CODE desc