SELECT
	A.CUST_CODE AS CODE
,	B.CUST_NAME AS NAME
,	COUNT(*) AS CNT
,	SUM(ORDER_AMNT) AS TTL_AMT
,	ROUND(SUM(ORDER_AMNT)  * 1.0 / COUNT(*), 0) AS AVG_AMT
FROM
	ORDERS A
,	CUSTOMER B
WHERE
	A.CUST_CODE = B.CUST_CODE
AND	ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
	A.CUST_CODE
,	B.CUST_NAME
HAVING
	COUNT(*) >= 5
ORDER BY
	CNT DESC
,	AVG_AMT DESC
,	CODE
LIMIT 5