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