WITH SEP_ORDER AS (
SELECT
    CUST_CODE,
    COUNT(ORDER_NO) AS CNT,
    SUM(ORDER_AMNT) AS TTL_AMT,
    AVG(ORDER_AMNT) AS AVG_AMT
FROM
    ORDERS
WHERE
    DATE(ORDER_DATE) BETWEEN '2023-09-01' AND '2023-09-30'
GROUP BY
    1
)
SELECT
    CUST_CODE AS CODE,
    CUST_NAME AS NAME,
    CNT,
    TTL_AMT,
    ROUND(AVG_AMT)
FROM
    SEP_ORDER
INNER JOIN
    CUSTOMER USING(CUST_CODE)
ORDER BY
    3 DESC,
    5 DESC,
    1