select
 O.CUST_CODE as CODE,
 C.CUST_NAME as NAME,
 count(O.CUST_CODE) as CNT,
 sum(ORDER_AMNT) as TTL_AMT,
 round(avg(ORDER_AMNT), 0) as AVG_AMT
from
 (select
  *
 from
  ORDERS
 where
  ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30') as O
 inner join CUSTOMER as C
 on O.CUST_CODE = C.CUST_CODE
group by O.CUST_CODE
order by
 CNT DESC,
 AVG_AMT DESC,
 CODE