SELECT 
    O.CUST_CODE AS 'CODE'
    ,CUST_NAME AS 'NAME'
    ,COUNT(ORDER_NO) AS 'CNT'
    ,SUM(ORDER_AMNT) AS 'TTL_AMT'
    ,ROUND(CAST(SUM(ORDER_AMNT) AS FLOAT)/COUNT(ORDER_NO),0) AS 'AVG_AMT'
FROM 
    ORDERS O
    LEFT JOIN CUSTOMER C
    ON O.CUST_CODE = C.CUST_CODE
WHERE
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY 
    O.CUST_CODE
ORDER BY
    CNT DESC
    ,AVG_AMT DESC
    ,CODE ASC