SELECT
    MAIN.CODE,
    MAIN.NAME,
    MAIN.CNT,
    MAIN.TTL_AMT,
    MAIN.AVG_AMT
FROM
    (
        SELECT
            CUS.CUST_CODE AS CODE,
            CUS.CUST_NAME AS NAME,
            COUNT(ORD.ORDER_NO) AS CNT,
            SUM(ORD.ORDER_AMNT) AS TTL_AMT,
            ROUND(AVG(ORD.ORDER_AMNT)) AS AVG_AMT
        FROM
            CUSTOMER CUS
        INNER JOIN
            ORDERS ORD ON CUS.CUST_CODE = ORD.CUST_CODE
        WHERE
            ORD.ORDER_DATE >= '2023-09-01'
            AND ORD.ORDER_DATE <= '2023-09-30'
        GROUP BY
            CUS.CUST_CODE, CUS.CUST_NAME
        HAVING
            COUNT(ORD.ORDER_NO) >= 5
        ORDER BY
            CNT DESC,
            AVG_AMT DESC,
            CODE ASC
        LIMIT 5
    ) MAIN;