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
group by 1
order by 1 desc;