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