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