with tbl1 as (
    select *
    from ORDERS
        left join CUSTOMER
        on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
    where ORDER_DATE between '2023-09-01' and '2023-09-30'
)
,tbl2 as (
    select 
        CUST_CODE as CODE
        ,CUST_NAME as NAME
        ,count(*) as CNT
        ,sum(ORDER_AMNT) as TTL_AMT
        ,round(cast(sum(ORDER_AMNT) as real)/cast(count(*) as real),0) as AVG_AMT
    from tbl1
    group by 
        CUST_CODE
)
select *
from tbl2
where CNT>=5
order by
    CNT desc
    ,AVG_AMT desc
    ,CODE
LIMIT 5