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