SELECT
  c.CUST_CODE AS CODE,
  c.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), 0) AS AVG_AMT
FROM
  ORDERS
JOIN
  CUSTOMER c ON ORDERS.CUST_CODE = c.CUST_CODE
WHERE
  ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
  c.CUST_CODE, c.CUST_NAME
HAVING
  CNT >= 5
ORDER BY
  CNT DESC, AVG_AMT DESC, CODE ASC
LIMIT 5;