with first_logins as (
    select
        member_code,
        min(date(login_datetime)) as first_login
    from access_log
    group by 1
)

select
    first_login,
    count(distinct member_code) as member_cnt
from first_logins
where first_login >= '2023-08-01' and first_login < '2023-09-01'
group by 1
order by 1 desc;