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