SELECT
    OD.CUST_CODE AS CODE
    , CU.CUST_NAME AS NAME
    , COUNT(ORDER_NO) AS CNT
    , SUM(OD.ORDER_AMNT) AS TTL_AMT
    , ROUND(SUM(OD.ORDER_AMNT)/COUNT(ORDER_NO),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;