with a as(
select
    t.CUST_CODE as CODE,
    m.CUST_NAME as NAME,
    count(t.ORDER_NO) as CNT,
    sum(t.ORDER_AMNT) as TTL_AMT,
    round(avg(t.ORDER_AMNT),0) as AVG_AMT
FROM
    ORDERS as t
inner join
    CUSTOMER as m on t.CUST_CODE = m.CUST_CODE
where
    ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
group by
    t.CUST_CODE
)
select
    CODE,
    NAME,
    CNT,
    TTL_AMT,
    AVG_AMT
from
    a
where
    CNT >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE
;