select
i.ITEM_CODE as CODE,
i.ITEM_NAME as NAME,
sum(d.UNITPRICE * d.ORDER_QTY) as TOTAL_AMT
from 
orders o, orders_dtl d, item i
where
o.ORDER_NO = d.ORDER_NO
and d.ITEM_CODE = i.ITEM_CODE
and o.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by 1,2
order by 3 desc ,1
limit 5