select
    FIRST_LOGIN,
    count(member_code) as MEMBER_CNT
from (
    select
    min(date(login_datetime)) as FIRST_LOGIN,
    member_code
from access_log
where date(login_datetime) between '2023-08-01' and '2023-08-31'
group by member_code
)
group by first_login
order by first_login desc;