SELECT
  C.CUST_CODE AS CODE,
  C.CUST_NAME AS NAME,
  COUNT(*) AS CNT,
  SUM(O.ORDER_AMNT) AS TTL_AMT,
  ROUND(AVG(O.ORDER_AMNT), 0) AS AVG_AMT
FROM
  CUSTOMER C
JOIN
  ORDERS O ON C.CUST_CODE = O.CUST_CODE
WHERE
  O.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;