select  C.CUST_CODE CODE
        ,C.CUST_NAME NAME
        ,COUNT(R.ORDER_NO) CNT
        ,SUM(R.ORDER_AMNT) TTL_AMT
        ,round(AVG(R.ORDER_AMNT),0) AVG_AMT

  from  ORDERS R
        ,CUSTOMER C
 where  R.CUST_CODE = C.CUST_CODE
   and  R.ORDER_DATE >= '2023-09-01'
   and  R.ORDER_DATE <= '2023-09-30'
 group by C.CUST_CODE,C.CUST_NAME
  having count(*) > 4
 order by COUNT(R.ORDER_NO) DESC,round(AVG(R.ORDER_AMNT),0) DESC,C.CUST_CODE
  limit 5