with ORD as(
select CUST_CODE as CODE,
count(1) as CNT,
sum(ORDER_AMNT) as TTL_AMT
from ORDERS
where ORDER_DATE between "2023-09-01" and "2023-09-31"
group by CODE
)
select o.CODE,c.CUST_NAME as NAME, o.CNT, o.TTL_AMT, round(1.0*o.TTL_AMT/o.CNT) as AVG_AMT
from ORD o left join CUSTOMER c on o.CODE = c.CUST_CODE
order by CNT desc, AVG_AMT desc, CODE