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