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