select
C.CUST_CODE as CODE,
C.CUST_NAME as NAME,
count(O.ORDER_NO) as CNT,
sum(O.ORDER_AMNT) as TTL_AMT,
round(cast(sum(O.ORDER_AMNT) as REAL)/count(O.ORDER_NO)) as AVG_AMT
from ORDERS as O
inner join CUSTOMER as C
on C.CUST_CODE = O.CUST_CODE
where O.ORDER_DATE between '2023-09-01' and '2023-09-30'
group by C.CUST_CODE
order by CNT desc, AVG_AMT desc, CODE asc
limit 5;