SELECT
    c.CUST_CODE AS CODE,
    c.CUST_NAME AS NAME,
    COUNT(*) AS CNT,
    SUM(ORDER_AMNT) AS TTL_AMT,
    (SUM(ORDER_AMNT)/COUNT(*)) AS AVG_AMT
FROM
    ORDERS as o
LEFT JOIN
    CUSTOMER as c
ON
    c.CUST_CODE = o.CUST_CODE
WHERE
    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;