select o.CUST_CODE as CODE, c.CUST_NAME  as NAME, count(*) as CNT, sum(o.ORDER_AMNT) as TTL_AMT, round(avg(o.ORDER_AMNT)) as AVG_AMT
from ORDERS o 
inner join CUSTOMER c on o.CUST_CODE = c.CUST_CODE
where ORDER_DATE between '2023-09-01' and '2023-09-30'
and (select count(*) from ORDERS group by CUST_CODE)>=5
group by c.CUST_CODE 
order by CNT desc, AVG_AMT desc, CODE
limit 5;