select o.cust_code as CODE, c.cust_name as NAME, count(*) 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 c.cust_code = o.cust_code
where order_date >= '2023-09-01' and order_date <= '2023-09-30'
group by o.cust_code
having count(*) < 5
order by count(*) and round(avg(o.order_amnt)) and o.cust_code;