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