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" and "2023-08-31"
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc