WITH base AS (
	SELECT
		CUST_CODE
		,COUNT(ORDER_NO) AS CNT
		,SUM(ORDER_AMNT) AS TTL_AMT
		,ROUND(AVG(ORDER_AMNT),0) AS AVG_AMT
	FROM ORDERS
	WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
	GROUP BY 1
	HAVING CNT >= 5
)
SELECT
	t0.CUST_CODE AS CODE
	,t1.CUST_NAME AS NAME
	,t0.CNT
	,t0.TTL_AMT
	,t0.AVG_AMT
FROM base AS t0
INNER JOIN CUSTOMER AS t1
	ON t0.CUST_CODE = t1.CUST_CODE
ORDER BY CNT DESC,AVG_AMT DESC,t0.CUST_CODE ASC
LIMIT 5