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