select
o.CUST_CODE as CODE
, c.CUST_NAME as NAME
, count(1) as CNT
, sum(ORDER_AMNT) as TTL_AMT
, ROUND(AVG(ORDER_AMNT)) as AVG_AMT
from orders as o join customer c on o.CUST_CODE = c.CUST_CODE
where o.ORDER_DATE between '2023-09-01' and '2023-09-30'
group by o.CUST_CODE
having CNT >= 5
order by CNT desc, AVG_AMT desc, CODE asc
limit 5