WITH ods AS(
    SELECT
			CUST_CODE
			,COUNT(ORDER_NO) AS CNT
			,SUM(ORDER_AMNT) AS TTL_AMT
			,AVG(ORDER_AMNT) AS AVG_AMT
		FROM
			ORDERS
		WHERE
			ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
		GROUP BY
			CUST_CODE
)
SELECT
	ods.CUST_CODE AS CODE
	,cst.CUST_NAME AS NAME
	,ods.CNT
	,ods.TTL_AMT
	,ROUND(ods.AVG_AMT) AS AVG_AMT
FROM
	ods
		INNER JOIN CUSTOMER cst
		ON ods.CUST_CODE = cst.CUST_CODE
WHERE
	ods.CNT >= 5
ORDER BY
	ods.CNT DESC,ods.AVG_AMT DESC,ods.CUST_CODE
limit 5