SELECT
    LOGIN_DATETIME AS FIRST_LOGIN,
    COUNT(ACCESS_ID) AS MEMBER_CNT
FROM    
    (
    SELECT
        MIN(DATE(LOGIN_DATETIME)) as LOGIN_DATETIME,
        ACCESS_ID
    FROM
        ACCESS_LOG
    WHERE
        LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31 23:59:59'
    GROUP BY
        ACCESS_ID
    )
GROUP BY
    LOGIN_DATETIME
ORDER BY
    FIRST_LOGIN DESC