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