select FIRST_LOGIN, count(*) MEMBER_CNT
from (
    select date(MIN(LOGIN_DATETIME)) as FIRST_LOGIN, MEMBER_CODE
    FROM ACCESS_LOG
    WHERE LOGIN_DATETIME < "2023-09-01 00:00:00"
    group by MEMBER_CODE
)
WHERE FIRST_LOGIN >= "2023-08-01 00:00:00"
group by FIRST_LOGIN
order by FIRST_LOGIN DESC;