WITH a AS (
    SELECT
        ORDERS.CUST_CODE AS CODE,
        CUST_NAME AS NAME,
        count(*) AS CNT,
        round(avg(ORDER_AMNT)) AS AVG_AMT,
        sum(ORDER_AMNT) AS TTL_AMT
    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
    *
FROM
    a
WHERE
    cnt > 4
LIMIT
    5