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