select FIRST_LOGIN
, count(*) MEMBER_CNT
from (
select A.MEMBER_CODE
, min(date(A.LOGIN_DATETIME)) FIRST_LOGIN
from ACCESS_LOG A
group by A.MEMBER_CODE
having min(date(A.LOGIN_DATETIME)) >= '2023-08-01'
and min(date(A.LOGIN_DATETIME)) < '2023-09-01'
)
group by FIRST_LOGIN
order by FIRST_LOGIN desc