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