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