SELECT
    FIRST_LOGIN
    , COUNT(*) AS MEMBER_CNT
FROM
    (
        SELECT
            MEMBER_CODE
            , DATE(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN
        FROM
            ACCESS_LOG
        GROUP BY
            MEMBER_CODE
        HAVING
            MIN(LOGIN_DATETIME) BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
    )
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC
;