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