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