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