with tmp as(
select MEMBER_CODE as CODE,
min(DATE(LOGIN_DATETIME)) as FIRST_LOGIN
from ACCESS_LOG
--where DATE(LOGIN_DATETIME) between "2023-08-01" and "2023-08-31"
group by CODE
)
select FIRST_LOGIN,
count(1) as MEMBER_CNT
from tmp 
where FIRST_LOGIN between "2023-08-01" and "2023-08-31"
group by FIRST_LOGIN
order by FIRST_LOGIN desc