select OD.ITEM_CODE CODE,
I.ITEM_NAME NAME,
sum(OD.UNITPRICE * OD.ORDER_QTY) TOTAL_AMT

from ORDERS_DTL OD 
inner join  ITEM I on (OD.ITEM_CODE = I.ITEM_CODE)
inner join ORDERS O on (OD.ORDER_NO = O.ORDER_NO)

where ORDER_DATE between '2023-05-14' and '2023-05-20'
group by I.ITEM_NAME

order by TOTAL_AMT desc,
CODE desc


limit 5;