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