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