select
    FIRST_LOGIN
    , count(MEMBER_CODE) as MEMBER_CNT
from
    (select
        MEMBER_CODE
        , strftime('%Y-%m-%d', MIN(LOGIN_DATETIME)) as FIRST_LOGIN
    from
        ACCESS_LOG
    group by
        MEMBER_CODE
    order by
        MEMBER_CODE desc
    )
where
    FIRST_LOGIN between "2023-08-01 00:00:00" and "2023-08-31 23:59:59"
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc