select 
    date(min_LOGIN_DATETIME) as FIRST_LOGIN
    ,count(MEMBER_CODE) as MEMBER_CNT 

from (
    select 
        MEMBER_CODE
        ,min(LOGIN_DATETIME) as min_LOGIN_DATETIME
    from  ACCESS_LOG
    group by 1
)
group by 1 order by 1
;