select
  c.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 as o
       join CUSTOMER as c
           on o.CUST_CODE = c.CUST_CODE
 where date(o.ORDER_DATE) >= date('2023-09-01')
   and date(o.ORDER_DATE) <= date('2023-09-30')
 group by o.CUST_CODE
having count(*) >= 5
 order by
   CNT desc,
   AVG_AMT desc,
   CODE asc
       ;