with first_login as(
    select    
        MEMBER_CODE, 
        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 MEMBER_CODE 
    
)
select
    first_login_date as FIRST_LOGIN,
    count(MEMBER_CODE) as MEMBER_CNT
from first_login
group by first_login_date
order by FIRST_LOGIN desc
;