SELECT
    O.CUST_CODE AS CODE,
    C.CUST_NAME AS NAME,
    COUNT(O.CUST_CODE) AS CNT,
    (SUM(O.ORDER_AMNT)) AS TTL_AMT,
    ROUND(AVG(O.ORDER_AMNT)) AS AVG_AMT
FROM ORDERS AS O
LEFT JOIN CUSTOMER AS C
    ON O.CUST_CODE=C.CUST_CODE
WHERE 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;