select FIRST_DATE as FIRST_LOGIN
    , count(*) as MEMBER_CNT
from (    
    select 
    DATE(min(LOGIN_DATETIME)) as FIRST_DATE
    ,MEMBER_CODE
    from ACCESS_LOG
    where LOGIN_DATETIME between '2023-08-01' and '2023-08-31'
    and MEMBER_CODE not in (
        select MEMBER_CODE from ACCESS_LOG
        where LOGIN_DATETIME < '2023-08-01'
    )
    group by MEMBER_CODE
)
group by FIRST_DATE
order by FIRST_LOGIN desc