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