with t1 as(
select
MEMBER_CODE,
strftime('%Y-%m-%d',min(LOGIN_DATETIME)) as FIRST_LOGIN
from access_log
where
 MEMBER_CODE not in (select distinct MEMBER_CODE FROM access_log where DATETIME(LOGIN_DATETIME) <= DATETIME('2023-07-31'))
group by MEMBER_CODE
)
select FIRST_LOGIN, count(1) as MEMBER_CNT from t1 
where FIRST_LOGIN between '2023-08-01' and '2023-08-31 23:59:59'
group by 1 order by 1 desc