WITH ORDERS_202309 AS (
    SELECT
        CUST_CODE
        , ORDER_AMNT
    FROM
        ORDERS
    WHERE
        ORDER_DATE BETWEEN '2023-09-01' AND '2023-09-30'
)

SELECT
    ORDERS_202309.CUST_CODE AS CODE
    , CUSTOMER.CUST_NAME AS NAME
    , COUNT(ORDERS_202309.ORDER_AMNT) AS CNT
    , SUM(ORDERS_202309.ORDER_AMNT) AS TTL_AMT
    , ROUND(SUM(ORDERS_202309.ORDER_AMNT) * 1.0 / COUNT(ORDERS_202309.ORDER_AMNT)) AS AVG_AMT
FROM
    ORDERS_202309
INNER JOIN
    CUSTOMER ON ORDERS_202309.CUST_CODE = CUSTOMER.CUST_CODE
GROUP BY
    ORDERS_202309.CUST_CODE
HAVING
    COUNT(ORDERS_202309.ORDER_AMNT) >= 5
ORDER BY
    CNT DESC
    , AVG_AMT DESC
    , CODE ASC
;