SELECT
	T3.ITEM_CODE AS CODE,
	T3.ITEM_NAME AS NAME,
	SUM(T1.UNITPRICE * T1.ORDER_QTY) AS TOTAL_AMT
FROM ORDERS_DTL T1
INNER JOIN ORDERS T2
ON
	T1.ORDER_NO = T2.ORDER_NO
INNER JOIN ITEM T3
ON
	T1.ITEM_CODE = T3.ITEM_CODE
WHERE
	T2.ORDER_DATE >= '2023-05-14'
AND	T2.ORDER_DATE <= '2023-05-20'
GROUP BY T3.ITEM_CODE
ORDER BY
	TOTAL_AMT DESC,
	CODE DESC
LIMIT 5