with first_logins as (
select  date(min(LOGIN_DATETIME)) as FIRST_LOGIN, MEMBER_CODE
from access_log
group by MEMBER_CODE
)
select FIRST_LOGIN, count(1) as MEMBER_CNT from first_logins
where FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by FIRST_LOGIN 
order by FIRST_LOGIN desc