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