select o.CUST_CODE AS CODE,
 CUST_NAME AS NAME,
 count(o.CUST_CODE) AS CNT,
 SUM(o.ORDER_AMNT) AS TTL_AMT,
 round(AVG(o.ORDER_AMNT)) AS AVG_AMT
from ORDERS o
left outer join CUSTOMER c on o.cust_code = c.cust_code
where ORDER_DATE between '2023-09-01' and '2023-09-30'
group by o.CUST_CODE
having count(o.CUST_CODE) >= 5
order by CNT desc,AVG_AMT desc,CODE
limit 5