select 
OL.ITEM_CODE as CODE,
IM.ITEM_NAME as NAME,
SUM(OL.UNITPRICE*OL.ORDER_QTY) as TOTAL_AMT
from ORDERS_DTL as OL
    inner join ORDERS as OS on OL.ORDER_NO =OS.ORDER_NO
    inner join ITEM as IM on OL.ITEM_CODE =IM.ITEM_CODE
where ORDER_DATE between '2023-05-14' and '2023-05-20'
group by CODE
order by TOTAL_AMT desc,CODE desc
limit 5