WITH A AS (
    SELECT
        CUST_CODE,
        COUNT
    FROM (
        SELECT 
            CUST_CODE,
            COUNT(CUST_CODE) AS COUNT
        FROM
            ORDERS
        WHERE
            ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
        GROUP BY
            CUST_CODE
    )
    WHERE
        COUNT >= 5
)
SELECT
    ORDERS.CUST_CODE AS CODE,
    CUSTOMER.CUST_NAME AS NAME,
    COUNT(*) AS CNT,
    SUM(ORDERS.ORDER_AMNT) AS TTL_AMT,
    ROUND(CAST(SUM(ORDERS.ORDER_AMNT) AS float) / COUNT(*), 0) AS AVG_AMT
FROM
    ORDERS
JOIN
    CUSTOMER USING(CUST_CODE)
JOIN
    A USING(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
LIMIT 5
;