select
    c.cust_code CODE
    ,c.cust_name NAME
    ,count(*) CNT
    ,sum(order_amnt) TTL_AMT
    ,round(sum(order_amnt)*1.0 / count(*)) AVG_AMT
from
    orders o left join customer c on o.cust_code = c.cust_code
where
    order_date between '2023-09-01' and '2023-09-31'
group by
    c.cust_code
    ,c.cust_name
having
    cnt >= 5
order by
    cnt desc, avg_amt desc, code asc
limit 5
;