SELECT DISTINCT CUSTOMER.CUST_CODE AS CODE , CUSTOMER.CUST_NAME AS NAME ,
       COUNT(ORDER_NO)OVER(PARTITION BY CUSTOMER.CUST_CODE) AS CNT,
       SUM(ORDER_AMNT)OVER(PARTITION BY CUSTOMER.CUST_CODE) AS TTL_AMT,
       round(AVG(ORDER_AMNT)OVER(PARTITION BY CUSTOMER.CUST_CODE),0) AS AVG_AMT
FROM CUSTOMER JOIN ORDERS ON(CUSTOMER.CUST_CODE = ORDERS.CUST_CODE)
WHERE ORDER_DATE BETWEEN '2023-09-01' AND '2023-10-01'
ORDER BY CNT DESC,AVG_AMT DESC,CODE