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