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
)
where FIRST_LOGIN between date('2023-08-01') and date('2023-08-31')
group by 1 order by 1 desc
;