select
    orders.cust_code CODE,
    cust_name NAME,
    count(cust_name) CNT,
    sum(order_amnt) TTL_AMT,
    round(cast(sum(order_amnt) as double) / count(cust_name)) AVG_AMT
from orders
join customer
on orders.cust_code = customer.cust_code
where order_date between '2023-09-01' and '2023-09-30'
group by orders.cust_code
having count(cust_name) >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE
limit 5