SELECT
C.CUST_CODE CODE,
C.CUST_NAME NAME,
COUNT(C.CUST_CODE) CNT,
SUM(O.ORDER_AMNT) TTL_AMT,
ROUND(1.0*SUM(O.ORDER_AMNT)/COUNT(C.CUST_CODE),0) AVG_AMT
FROM 
    ORDERS O
INNER JOIN 
	CUSTOMER C ON O.CUST_CODE = C.CUST_CODE
WHERE
    ORDER_DATE BETWEEN "2023-09-01" AND "2023-09-30"
GROUP BY
    C.CUST_CODE
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE ASC