SELECT 
substr(LOGIN_DATETIME,1,10) as FIRST_LOGIN,
count(DISTINCT MEMBER_CODE) as MEMBER_CN,
MEMBER_CODE
from
(select date(min(LOGIN_DATETIME))as LOGIN_DATETIME,MEMBER_CODE from ACCESS_LOG
where strftime('%Y-%m',LOGIN_DATETIME)='2023-08'
group by MEMBER_CODE) as FR

where
FIRST_LOGIN between '2023-08-01'and'2023-08-31'

group by date(FIRST_LOGIN)
ORDER BY
FIRST_LOGIN DESC