select
     c.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 as o
inner join
    customer as c
on
    o.cust_code = c.cust_code
where
    o.order_date >= "2023-09-01"
and o.order_date <= "2023-09-30"
group by
    NAME
order by
    CNT desc,
    AVG_AMT desc,
    CODE