select o.cust_code as CODE, c.cust_name as NAME, count(o.order_no) as CNT, sum(o.order_amnt) as TTL_AMT, round(avg(o.order_amnt)) as AVG_AMT
from orders o
join
customer c
on c.cust_code = o.cust_code
where o.order_date like '2023-09-%'
group by o.cust_code
having count(o.order_no) >= 5
order by o.cust_code , count(o.order_no) desc , avg(o.order_amnt) desc;