SELECT
    FIRST_LOGIN,
    COUNT(1) AS MEMBER_CNT
FROM (
    SELECT
        MEMBER_CODE,
        MIN(LOGIN_DATETIME) AS f,
        MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)
WHERE
    f >= "2023-08-01 00:00:00"
    AND f < "2023-09-01 00:00:00"
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC