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