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