select
DATE(m) as FIRST_LOGIN
,COUNT(*) as MEMBER_CNT
from(
    select
    member_code
    ,min(login_datetime) as m
    from access_log
    group by member_code
    having m between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
) as T
group by date(m)
order by FIRST_LOGIN desc