select ORDERS.CUST_CODE as CODE
      ,CUSTOMER.CUST_NAME as NAME
      ,COUNT(ORDERS.CUST_CODE) as CNT
      ,SUM(ORDERS.ORDER_AMNT) as TTL_AMT
      ,ROUND(SUM(ORDERS.ORDER_AMNT) / COUNT(ORDERS.CUST_CODE)) as AVG_AMT
  from ORDERS
    inner join CUSTOMER
      on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
  where ORDERS.ORDER_DATE >= '2023-09-01'
    and ORDERS.ORDER_DATE <= '2023-09-30'
  group by ORDERS.CUST_CODE
  having CNT >= 5
  order by AVG_AMT desc, CODE asc;
  
  --CNT desc, AVG_AMT desc, CODE asc;