select orders.cust_code as CODE
	,cust_name as NAME
	,count(orders.cust_code) as CNT
	,sum(orders.order_amnt) as TTL_AMT
	,round(sum(orders.order_amnt) / count(orders.cust_code),1) as AVG_AMT
from orders 
left outer join customer
on orders.cust_code = customer.cust_code
where substr(orders.order_date,1,10) between '2023-09-01' and '2023-09-30'
group by orders.cust_code,cust_name
having (CNT > 4)
order by CNT desc,AVG_AMT desc,CODE asc