SELECT
    CUS.CUST_CODE AS CODE
    , CUS.CUST_NAME AS NAME
    , COUNT(*) AS CNT
    , SUM(ORD.ORDER_AMNT) AS TTL_AMT
    , ROUND(AVG(ORD.ORDER_AMNT), 0) AS AVG_AMT
FROM
    CUSTOMER AS CUS
    INNER JOIN ORDERS AS 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
HAVING
    count(*) >= 5
ORDER BY
    CNT DESC
    , AVG_AMT DESC
    , CODE ASC
LIMIT 5