select
OD.ITEM_CODE as CODE,
I.ITEM_NAME as NAME,
OD.UNITPRICE * OD.ORDER_QTY as TOTAL_AMT
from 
ORDERS as O
inner join ORDERS_DTL as OD
on O.ORDER_NO = OD.ORDER_NO
inner join ITEM as I
on OD.ITEM_CODE = I.ITEM_CODE
where
O.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by CODE,NAME
order by TOTAL_AMT desc,OD.ITEM_CODE desc
limit 5;