select ITEM.ITEM_CODE as CODE,
ITEM.ITEM_NAME as NAME,
ORDERS_DTL.UNITPRICE*ORDERS_DTL.ORDER_QTY as TOTAL_AMT
from ITEM
INNER JOIN ORDERS_DTL
on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
INNER JOIN ORDERS
on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
where ORDERS.ORDER_DATE between '2023-05-14' and '2023-05-20'
order by TOTAL_AMT DESC,
CODE DESC;