select OD.ITEM_CODE as CODE, ITEM_NAME as NAME,UNITPRICE * 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 I.ITEM_CODE = OD.ITEM_CODE
group by NAME
having ORDER_DATE between '2023-05-14' and '2023-05-20'
order by TOTAL_AMT desc,CODE desc limit 5