with first_login as(
    select    
        ACCESS_ID as id, 
        min(date(LOGIN_DATETIME)) as first_login_date
    from ACCESS_LOG
    where date(LOGIN_DATETIME) between '2023-08-01' and '2023-08-31'
    group by ACCESS_ID 
    
)
select
    first_login_date as FIRST_LOGIN,
    count(id) as MEMBER_CNT
from first_login
group by first_login_date
order by FIRST_LOGIN desc
;