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