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