SELECT T1.CUST_CODE AS CODE,
       T2.CUST_NAME AS NAME,
       T1.CNT,
       T1.TTL_AMT,
       T1.AVG_AMT
  FROM (SELECT CUST_CODE ,
               COUNT(*) AS CNT,
               SUM(ORDER_AMNT) AS TTL_AMT,
               ROUND(AVG(ORDER_AMNT)) AS AVG_AMT
          FROM ORDERS
         WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
         GROUP BY CUST_CODE
       ) T1 INNER JOIN CUSTOMER T2
               ON T1.CUST_CODE = T2.CUST_CODE
 ORDER BY T1.CNT DESC,T1.AVG_AMT DESC,CODE ASC