select 
    o.CUST_CODE as CODE
    ,max(CUST_NAME) as NAME
    ,count(*) as CNT
    ,sum(ORDER_AMNT) as TTL_AMT
    ,round(avg(ORDER_AMNT),0) as AVG_AMT
from ORDERS o
inner join CUSTOMER c on o.CUST_CODE=c.CUST_CODE
where (ORDER_DATE between '2023-09-01' and '2023-09-30')
group by o.CUST_CODE
having count(*)>=5
order by 3 desc, 5 desc ,1
limit 5;