SELECT
  cust.CUST_CODE AS CODE,
  cust.CUST_NAME AS NAME,
  COUNT(ORDER_NO) AS CNT,
  SUM(ORDER_AMNT) AS TTL_AMT,
  ROUND(CAST(SUM(ORDER_AMNT) AS REAL) / COUNT(ORDER_NO)) AS AVG_AMT
FROM
  CUSTOMER AS cust
  LEFT OUTER JOIN ORDERS AS ord ON cust.CUST_CODE = ord.CUST_CODE
WHERE
  ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
  cust.CUST_CODE
ORDER BY
  CNT desc,
  AVG_AMT desc,
  CODE asc;