select cs.cust_code as CODE ,
       cs.cust_name as NAME , 
       count(cs.cust_code) as CNT , 
       sum(OD.order_AMNT) as TTL_AMT , 
       ROUND(AVG(cast(OD.order_AMNT as real )),0) as AVG_AMT
from 
    orders OD
    
    inner join CUSTOMER cs 
        on OD.cust_code = CS.cust_code
where 
    OD.order_date between '2023-09-01' and '2023-09-30'
    
group by
    OD.cust_code , CS.cust_name
    
having 
    cnt >= 5
    
order by 
    CNT desc , 
    AVG_AMT desc , 
    CODE

limit 5;