select 
 i.ITEM_CODE as CODE
 ,i.ITEM_NAME as NAME
 ,sum(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from 
    ORDERS o 
join ORDERS_DTL od on o.ORDER_NO = od.ORDER_NO
join ITEM i on od.ITEM_CODE = i.ITEM_CODE
where 
     o.ORDER_DATE >= '2023-05-14'  AND o.ORDER_DATE <= '2023-05-20'
group by CODE
order by TOTAL_AMT desc,i.ITEM_CODE desc
limit 5
;