select
    d as FIRST_LOGIN,
    count(member_code) as MEMBER_CNT
from(
    select
        member_code,
        min(date(login_datetime)) as d
    from
        access_log
    group by
        member_code
    )
where
    d between "2023-08-01" and "2023-08-31"
group by
    d
order by
    d desc