select
c.CUST_CODE as CODE,
c.CUST_NAME as NAME,
count(*) as CNT,
sum(o.ORDER_AMNT) as  TTL_AMT,
round(avg(o.ORDER_AMNT)) AVG_AMT

from CUSTOMER c
join ORDERS o 
on c.CUST_CODE = o.CUST_CODE
where o.ORDER_DATE between '2023-09-01' and '2023-09-30'

group by c.CUST_CODE
having  CNT >= 5
order by CNT desc,AVG_AMT desc,CODE asc
;