WITH A AS (
    SELECT 
        CUST_CODE,
        COUNT(CUST_CODE) AS COUNT
    FROM
        ORDERS
    WHERE
        DATE(ORDER_DATE) BETWEEN DATE('2023-09-01') AND DATE('2023-09-30')
    GROUP BY
        CUST_CODE
)

SELECT
    ORDERS.CUST_CODE AS CODE,
    CUSTOMER.CUST_NAME AS NAME,
    COUNT(*) AS CNT,
    SUM(ORDERS.ORDER_AMNT) AS TTL_AMT,
    SUM(ORDERS.ORDER_AMNT) / COUNT(*) AS AVG_AMT
FROM
    ORDERS
JOIN
    CUSTOMER USING(CUST_CODE)
JOIN
    A USING(CUST_CODE)
WHERE
    DATE(ORDER_DATE) BETWEEN DATE('2023-09-01') AND DATE('2023-09-30') AND
    A.COUNT >= 5
GROUP BY
    ORDERS.CUST_CODE
ORDER BY
    CNT DESC,
    AVG_AMT DESC,
    CODE
;