WITH T AS(
    SELECT
        ORDERS.CUST_CODE AS CODE,
        CUST_NAME AS NAME,
        COUNT(*) AS CNT,
        SUM(ORDER_AMNT) AS TTL_AMT,
        ROUND(1.00 * SUM(ORDER_AMNT) / COUNT(*)) AS AVG_AMT,
        RANK() OVER(ORDER BY
            COUNT(*) DESC,
            ROUND(1.00 * SUM(ORDER_AMNT) / COUNT(*)) DESC,
            ORDERS.CUST_CODE ASC
        ) AS RNK
    FROM
        ORDERS
        INNER JOIN
            CUSTOMER ON ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
    WHERE
        ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
    GROUP BY
        ORDERS.CUST_CODE
    ORDER BY
        CNT DESC,
        AVG_AMT DESC,
        CODE ASC
)
SELECT
    CODE,
    NAME,
    CNT,
    TTL_AMT,
    AVG_AMT
FROM
    T
WHERE
     CNT >= 5 AND RNK <= 5