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
group by CS.cust_code , CS.cust_name 
having OD.order_date between '2023-09-01' and '2023-09-30'
order by CNT desc , AVG_AMT desc , CODE
limit 5;