with first_logins as (
select  date(min(LOGIN_DATETIME)) as FIRST_LOGIN, MEMBER_CODE
from access_log
where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'group by MEMBER_CODE
)
select FIRST_LOGIN, count(1) as MEMBER_CNT from first_logins group by FIRST_LOGIN order by FIRST_LOGIN desc