with tmp as (
    select date(min(login_datetime)) first_login_date
    from access_log
    group by member_code
)
select first_login_date FIRST_LOGIN, count(first_login_date) MEMBER_CNT
from tmp
where first_login_date >= '2023-08-01' and first_login_date <= '2023-08-31'
group by first_login_date
order by first_login_date desc