select
    c.cust_code as CODE
    ,c.cust_name as NAME
    ,count(o.ORDER_NO) as CNT
    ,sum(o.ORDER_AMNT) as TTL_AMT
    ,round(avg(o.ORDER_AMNT), 0) as AVG_AMT
from
    orders as o
    inner join customer as c
        on c.cust_code = o.cust_code                
where
    date(o.order_date) between date('2023-09-01') and date('2023-09-30')
group by
    c.cust_code
    having
        CNT >= 5
order by
    CNT desc
    ,AVG_AMT desc
    ,CODE asc
limit 5
;