with
    t as (
        select
            cust_code
            ,order_amnt
            ,count(order_amnt) over (partition by cust_code) as cnt
        from
            orders
        where
            order_date >= '2023-09-01'
            and order_date <= '2023-09-30'
    )
    
select
    t.cust_code as CODE
    ,c.cust_name as NAME
    ,t.cnt as CNT
    ,sum(t.order_amnt) as TTL_AMT
    ,round(avg(cast(t.order_amnt as real)), 0) as AVG_AMT
from
    t
join
    customer as c
on
    t.cust_code = c.cust_code
where
    cnt >= 5
group by
    1, 2, 3
order by
    cnt desc
    ,avg_amt desc
    ,code
limit
    5