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