SELECT
	CUSTOMER.CUST_CODE AS CODE
,	CUSTOMER.CUST_NAME AS NAME
,	COUNT(ORDERS.ORDER_NO) AS CNT
,	SUM(ORDERS.ORDER_AMNT) AS TTL_AMT
,	ROUND(cast(SUM(ORDERS.ORDER_AMNT) as REAL) / COUNT(ORDERS.ORDER_NO), 1)  AS AVG_AMT
FROM
	ORDERS
		INNER JOIN CUSTOMER
			ON CUSTOMER.CUST_CODE = ORDERS.CUST_CODE
WHERE
	ORDERS.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
	CUSTOMER.CUST_CODE
,	CUSTOMER.CUST_NAME
HAVING COUNT(ORDERS.ORDER_NO) >= 5
ORDER BY
	3 DESC
,	4 DESC
,	1 ASC
LIMIT 10
;