SELECT
    o.CUST_CODE as CODE,
    CUST_NAME as NAME,
    COUNT(o.CUST_CODE) as CNT,
    SUM(ORDER_AMNT) as TTL_AMT,
    SUM(ORDER_AMNT) / COUNT(o.CUST_CODE) as  AVG_AMT
FROM
    ORDERS as o
JOIN CUSTOMER as 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
ORDER BY 
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC