with sub as (
    select
        MIN(DATE(LOGIN_DATETIME)) as FIRST_LOGIN
        ,MEMBER_CODE
    from ACCESS_LOG
    group by MEMBER_CODE
    order by FIRST_LOGIN desc
    )
    
select
    FIRST_LOGIN
    ,count(*) as MEMBER_CNT
from sub
where FIRST_LOGIN between'2023-08-01' and '2023-08-31'
group by FIRST_LOGIN
order by FIRST_LOGIN desc