select
    cust_code code,
    cust_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, cust_code desc nulls last
limit 5