select
    o.cust_code as CODE
    ,c.cust_name as NAME
    ,count(*) as CNT
    ,sum(order_AMNT) as TTL_AMT
    ,round(sum(order_amnt)*1.0/count(*),0) as AVG_AMT
from orders as o
inner join customer as c
on o.cust_code = c.cust_code
where order_date between '2023-09-01' and '2023-09-30'
group by o.cust_code
having CNT >=5
order by cnt desc,avg_amt desc,code