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