WITH a AS (
    SELECT
        t.CUST_CODE AS CODE,
        m.CUST_NAME AS NAME,
        COUNT(t.ORDER_NO) AS CNT,
        SUM(t.ORDER_AMNT) AS TTL_AMT,
        ROUND(AVG(t.ORDER_AMNT), 0) AS AVG_AMT
    FROM
        ORDERS AS t
    INNER JOIN
        CUSTOMER AS m ON t.CUST_CODE = m.CUST_CODE
    WHERE
        ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
    GROUP BY
        t.CUST_CODE
)
SELECT
    CODE,
    NAME,
    CNT,
    TTL_AMT,
    AVG_AMT
FROM
    a
WHERE
    CNT >= 5
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE
LIMIT 5;