select
    cust_code CODE,
    cust_name NAME,
    count(order_no) CNT,
    sum(ORDER_AMNT) TTL_AMT,
    ROUND(CAST(sum(ORDER_AMNT) AS REAL) / CAST(count(order_no) AS REAL), 0) AVG_AMT
from orders o
join customer c using(cust_code)
where order_date between '2023-09-01' and '2023-09-30'
group by cust_code, cust_name
having CNT >= 5
order by CNT desc, TTL_AMT desc, CODE asc
limit 5