SELECT 
OD.ITEM_CODE as CODE,
I.ITEM_NAME as NAME,
SUM(OD.UNITPRICE * OD.ORDER_QTY) as TOTAL_AMT
FROM ORDERS_DTL as OD
INNER JOIN ORDERS as O
ON OD.ORDER_NO = O.ORDER_NO 
INNER JOIN ITEM as I
ON OD.ITEM_CODE = I.ITEM_CODE
WHERE O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY OD.ITEM_CODE
ORDER BY  TOTAL_AMT DESC, I.ITEM_CODE DESC
LIMIT 5;