WITH ods AS(
    SELECT
			CUST_CODE
			,COUNT(ORDER_NO) AS CNT
			,SUM(ORDER_AMNT) AS TTL_AMT
			,ROUND(AVG(ORDER_AMNT)) AS AVG_AMT
		FROM
			ORDERS
		WHERE
			ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
		GROUP BY
			CUST_CODE
		HAVING
		    COUNT(ORDER_NO) >= 5
)

SELECT
	ods.CUST_CODE AS CODE
	,cst.CUST_NAME AS NAME
	,ods.CNT
	,ods.TTL_AMT
	,ods.AVG_AMT
FROM
	ods
		INNER JOIN CUSTOMER cst
		ON ods.CUST_CODE = cst.CUST_CODE
ORDER BY ods.CNT DESC,ods.AVG_AMT DESC,ods.CUST_CODE