select
    FIRST_LOGIN
    , count(MEMBER_CODE) as MEMBER_CNT
from (
    select
        MEMBER_CODE
        , min(date(LOGIN_DATETIME)) as FIRST_LOGIN
    from ACCESS_LOG
    group by MEMBER_CODE
) t
where FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by 
    FIRST_LOGIN
order by 
    FIRST_LOGIN desc