SELECT
    o.CUST_CODE as CODE,
    CUST_NAME as NAME,
    COUNT(o.CUST_CODE) as CNT,
    SUM(ORDER_AMNT) as TTL_AMT,
    SUM(ORDER_AMNT) / COUNT(o.CUST_CODE) as AVG_AMT
FROM
    ORDERS as o
JOIN CUSTOMER as c on c.CUST_CODE = o.CUST_CODE
WHERE
    ORDER_DATE >= "2023-09-01 00:00:00"
AND
    ORDER_DATE <  "2023-10-01 00:00:00"
GROUP BY
    CODE