SELECT
    DATE(LOGIN_DATETIME) AS FIRST_LOGIN,
    COUNT(*) AS MEMBER_CNT
FROM
    ACCESS_LOG AS A
WHERE
    '2023-08-01' <= LOGIN_DATETIME
    AND LOGIN_DATETIME < '2023-09-01'
    AND NOT EXISTS (
        SELECT
            *
        FROM
            ACCESS_LOG AS B
        WHERE
            A.MEMBER_CODE = B.MEMBER_CODE
            AND B.LOGIN_DATETIME < A.LOGIN_DATETIME
    )
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC;