SELECT
    o.cust_code CODE,
    c.cust_name NAME,
    count(*) CNT,
    sum(ORDER_AMNT) TTL_AMT,
    round(avg(ORDER_AMNT), 0) AVG_AMT
    
FROM
    orders o
    inner join customer as c using(cust_code)
WHERE
    order_date between '2023-09-01' and '2023-09-30'
GROUP BY 
    1,2 
ORDER BY
3 desc,5 desc, 1