SELECT
  c.CUST_CODE AS CODE
, c.CUST_NAME AS NAME
, COUNT(o.ORDER_NO) 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
  COUNT(o.ORDER_NO) >= 5
ORDER BY
  COUNT(o.ORDER_NO) DESC
, AVG(o.ORDER_AMNT) DESC
, c.CUST_CODE
LIMIT
  5;