WITH OrderSummary AS (
  SELECT
    CUST_CODE,
    COUNT(*) AS CNT,
    SUM(ORDER_AMNT) AS TTL_AMT,
    ROUND(AVG(ORDER_AMNT), 1) AS AVG_AMT
  FROM
    ORDERS
  WHERE
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
  GROUP BY
    CUST_CODE
  HAVING
    CNT >= 5
)

SELECT
  O.CUST_CODE AS CODE,
  C.CUST_NAME AS NAME,
  O.CNT,
  O.TTL_AMT,
  O.AVG_AMT
FROM
  OrderSummary O
JOIN
  CUSTOMER C ON O.CUST_CODE = C.CUST_CODE
ORDER BY
  O.CNT DESC,
  O.AVG_AMT DESC,
  O.CUST_CODE ASC
LIMIT 5;