select
    date(LOGIN_DATETIME) as FIRST_LOGIN,
    count(login_datetime) as MEMBER_CNT
from
    access_log
where
    first_login >= "2023-08-01"
and first_login <= "2023-08-31"
group by
    first_login
order by
    first_login desc