select
a.ITEM_CODE AS CODE
,c.ITEM_NAME AS NAME
,SUM(a.UNITPRICE*a.ORDER_QTY) AS TOTAL_AMT
from 
ORDERS_DTL a
INNER JOIN
ORDERS b
ON
a.ORDER_NO = b.ORDER_NO
INNER JOIN 
ITEM c
ON
a.ITEM_CODE = c.ITEM_CODE
WHERE 
b.ORDER_DATE BETWEEN '2023-05-14' and '2023-05-20'
GROUP BY 
a.ITEM_CODE
ORDER BY 
SUM(a.UNITPRICE*a.ORDER_QTY) desc
,a.ITEM_CODE desc
LIMIT 5;