select 
itm.ITEM_CODE as CODE
,itm.ITEM_NAME as NAME
,SUM(dtl.UNITPRICE * dtl.ORDER_QTY) as TOTAL_AMT
from
ORDERS ord
left join
ORDERS_DTL dtl
on ord.ORDER_NO = dtl.ORDER_NO
left join
ITEM itm
on
dtl.ITEM_CODE = itm.ITEM_CODE
where
date(ord.ORDER_DATE) >= date('2023-05-14')
and date(ord.ORDER_DATE) < date('2023-05-21')
group by dtl.ITEM_CODE
order by TOTAL_AMT desc
,itm.ITEM_CODE desc
LIMIT 5