WITH A AS
(
    SELECT
        MEMBER_CODE,
        MIN(LOGIN_DATETIME) AS FIRST_LOGIN_DATETIME
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)
SELECT
    strftime('%Y-%m-%d', FIRST_LOGIN_DATETIME) AS FIRST_LOGIN,
    COUNT(*)
FROM
    A
WHERE
    FIRST_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