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