with base as (
select
    CUST_CODE
    ,count() as CNT
    ,sum(ORDER_AMNT) as TTL_AMT
    ,round(1.0*sum(ORDER_AMNT)/count(),0) as AVG_AMT
from
    ORDERS
where
    ORDER_DATE between "2023-09-01" and "2023-09-30"
group by
    CUST_CODE
having
    5<=CNT
)
select
    b.CUST_CODE as CODE
    ,c.CUST_NAME as NAME
    ,CNT
    ,TTL_AMT
    ,AVG_AMT
from
    base as b
    inner join
    CUSTOMER as c
    on b.CUST_CODE=c.CUST_CODE
order by
    CNT desc
    ,AVG_AMT desc
    ,CODE