SELECT
    CU.CUST_CODE AS CODE,
    CU.CUST_NAME AS NAME,
    COUNT(CU.CUST_CODE) AS CNT,
    SUM(OD.ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(OD.ORDER_AMNT)) AS AVG_AMT
FROM ORDERS AS OD
LEFT JOIN CUSTOMER AS CU
ON OD.CUST_CODE = CU.CUST_CODE
WHERE OD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-31'
GROUP BY CU.CUST_NAME
ORDER BY TTL_AMT DESC;