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'
    group by MEMBER_CODE
)
group by FIRST_DATE
order by FIRST_LOGIN desc