SELECT
    FIRST_LOGIN,
    COUNT(*) AS MEMBER_CNT
FROM (
    SELECT
        MEMBER_CODE,
        MIN(STRFTIME('%Y-%m-%d', LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
) AS LOGIN_DATES
WHERE
    FIRST_LOGIN BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC