SELECT
  ORD.CUST_CODE AS 'CODE',
  CUS.CUST_NAME AS 'NAME',
  COUNT(ORD.ORDER_NO) 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 'CUS'
ON
  ORD.CUST_CODE = CUS.CUST_CODE
WHERE
  ORD.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
  ORD.CUST_CODE
HAVING
  CNT >= 5
ORDER BY
  CNT DESC,
  AVG_AMT DESC,
  CODE ASC
LIMIT 5