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

select
    first_login as 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;