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