SELECT O.CUST_CODE AS CODE,
       C.CUST_NAME AS NAME,
       COUNT(*) AS CNT,
       SUM(O.ORDER_AMNT) AS TTL_AMT,
       ROUND(cast(SUM(O.ORDER_AMNT) as REAL)/cast(COUNT(*) as REAL)) AS AVG_AMT
  FROM ORDERS O
  LEFT JOIN CUSTOMER C
    ON C.CUST_CODE = O.CUST_CODE
 WHERE O.ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
 GROUP BY O.CUST_CODE
 HAVING COUNT(*) >= 5
 ORDER BY COUNT(*) DESC,
          ROUND(SUM(O.ORDER_AMNT) /COUNT(*)) DESC,
          O.CUST_CODE
 LIMIT 5