SELECT O.CUST_CODE AS CODE
      ,C.CUST_NAME AS NAME
      ,COUNT(O.CUST_CODE) AS CNT
      ,SUM(O.ORDER_AMNT) AS TTL_AMT
      ,ROUND(CAST(SUM(O.ORDER_AMNT) AS REAL) / CAST(COUNT(O.CUST_CODE) AS REAL), 0) AS AVG_AMT
FROM ORDERS AS O
JOIN CUSTOMER AS C
ON O.CUST_CODE = C.CUST_CODE
WHERE DATE(ORDER_DATE) BETWEEN '2023-09-01' AND '2023-10-01'
GROUP BY CODE
        ,NAME
HAVING CNT >= 5
ORDER BY CNT DESC
        ,AVG_AMT DESC
        ,CODE ASC