select
a.FIRST_LOGIN,
count(a.member_code) as MEMBER_CNT
from
(
select
member_code,
min(date(login_datetime)) as FIRST_LOGIN
from
access_log
group by
member_code
) a
where
substr(a.FIRST_LOGIN,1,7) = '2023-08'
group by
a.FIRST_LOGIN
order by
a.FIRST_LOGIN desc
;