select
    c.CUST_CODE as code
    ,cust_name as name
    ,count(distinct order_no)as  CNT
    ,sum(ORDER_AMNT	)asTTL_AMT
    ,round(sum(ORDER_AMNT)*1.0/count(distinct order_no))as AVG_AMT
from
    CUSTOMER as c
    join
     ORDERS as o
     on c.CUST_CODE=o.cust_code
where
    o.order_date between '2023-09-01' and '2023-09-30'
group by
    c.cust_code
having
    count(distinct order_no)>=5
order by
    cnt desc,AVG_AMT desc,code asc
limit 5