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