with sub1 as(
select
	 MEMBER_CODE
	,min(substr(LOGIN_DATETIME, 1, 10)) as FIRST_LOGIN
from
	ACCESS_LOG
group by
	MEMBER_CODE
)
select FIRST_LOGIN, count(*) as MEMBER_CNT
from sub1
where FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by FIRST_LOGIN
order by FIRST_LOGIN desc