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