SELECT
    LOGIN_DATETIME AS FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM    
    (
    SELECT
        MIN(DATE(LOGIN_DATETIME)) as LOGIN_DATETIME,
        MEMBER_CODE
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
    )
WHERE
    LOGIN_DATETIME LIKE '2023-08%'
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC