select
    date(login_datetime) as FIRST_LOGIN,
    count(member_code) as MEMBER_CNT
from
    (select * 
    from access_log
    group by member_code
    order by login_datetime desc)
where
    login_datetime between "2023-08-01" and "2023-09-01"
group by
    FIRST_LOGIN
order by
    first_login desc