select ORDERS.CUST_CODE as CODE ,CUSTOMER.CUST_NAME as NAME,count(*) as CNT,sum(ORDERS.ORDER_AMNT) as TTL_AMT,round((sum(ORDERS.ORDER_AMNT) / count(*) ), 1) as AVG_AMT
from ORDERS 
inner join CUSTOMER
on ORDERS.CUST_CODE = CUSTOMER.CUST_CODE
where ORDERS.ORDER_DATE >= '2023-09-01'
and ORDERS.ORDER_DATE <= '2023-09-30'
group by ORDERS.CUST_CODE
having count(*) >=5
order by count(*) desc ,AVG_AMT desc ,ORDERS.CUST_CODE