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