WITH TEMP_t AS(
    SELECT
        MEMBER_CODE
        , MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM
        ACCESS_LOG
    WHERE
        DATE(LOGIN_DATETIME) BETWEEN '2023-08-01' AND '2023-08-31'
    GROUP BY 1
)
SELECT
    FIRST_LOGIN
    , COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    TEMP_t
GROUP BY 1
ORDER BY 1 DESC;