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