with t1 as(
select
MEMBER_CODE,
strftime('%Y-%m-%d',min(LOGIN_DATETIME)) as FIRST_LOGIN
from access_log
where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
group by MEMBER_CODE
)
select FIRST_LOGIN, count(1) from t1 group by 1 order by 1 desc
-- select * from t1
-- LOGIN_DATETIME
-- from ACCESS_LOG
-- where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
-- order by LOGIN_DATETIME

-- select * from ACCESS_LOG where MEMBER_CODE= '20000'