with tmp as (
select 
    MEMBER_CODE
    ,date(min(LOGIN_DATETIME)) as FIRST_LOGIN
from ACCESS_LOG
where (LOGIN_DATETIME between '2023-08-01' and '2023-09-01')
group by MEMBER_CODE
order by FIRST_LOGIN
)
select 
    FIRST_LOGIN
    ,count(MEMBER_CODE) as MEMBER_CNT
from tmp
group by FIRST_LOGIN
order by 1 desc
;