select 
    ct.CUST_CODE as CODE,
    ct.CUST_NAME as NAME,
    count(od.ORDER_NO) as CNT,
    sum(od.ORDER_AMNT) as TTL_AMT,
    round(avg(od.ORDER_AMNT),0) as AVG_AMT
from CUSTOMER as ct
inner join ORDERS as od on ct.CUST_CODE = od.CUST_CODE
where
    od.ORDER_DATE between '2023-09-01' and '2023-09-31'
group by
    ct.CUST_CODE
having 
    count(od.ORDER_NO) >= 5
order by
    CNT desc,
    AVG_AMT desc,
    CODE asc
limit 5;