SELECT
      OD.CUST_CODE AS CODE
    , CU.CUST_NAME AS NAME
    , COUNT(*) AS CNT
    , sum(ORDER_AMNT) AS TTL_AMT
    , round(avg(ORDER_AMNT)) AS AVG_AMT
FROM
    ORDERS as OD
    INNER JOIN CUSTOMER as CU
     ON CU.CUST_CODE = OD.CUST_CODE
WHERE 
    DATE(ORDER_DATE) BETWEEN "2023-09-01" AND "2023-09-30"
GROUP BY 
    OD.CUST_CODE
ORDER BY
      CNT   desc
    , AVG_AMT DEsc
    , CODE ASC
;