SELECT
    CU.CUST_CODE AS CODE,
    CU.CUST_NAME AS NAME,
    COUNT(CU.CUST_CODE) AS CNT,
    SUM(OD.ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(OD.ORDER_AMNT)) AS AVG_AMT
FROM ORDERS AS OD
LEFT JOIN CUSTOMER AS CU
ON OD.CUST_CODE = CU.CUST_CODE
AND OD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-31'
GROUP BY CU.CUST_NAME
HAVING CNT >= 5
ORDER BY CNT DESC, AVG_AMT DESC, CODE
LIMIT 5
;