with o as 
    (
        select * from orders 
        where order_date >= '2023-09-01'
            and order_date <= '2023-09-30'
    )
select
    cust_code as CODE,
    cust_name as NAME,
    count(*) as CNT,
    sum(order_amnt) as TTL_AMT,
    round(avg(order_amnt)) as AVG_AMT
from o
join customer c
using (cust_code)
group by code
having CNT > 4
order by
CNT desc,
AVG_AMT desc,
CODE asc
limit 5
;