with TMP as (
select
    member_code
    ,min(date(login_datetime)) as D
from 
    ACCESS_LOG
group by 1
)


select 
    D as FIRST_LOGIN
    ,count(*) as MEMBER_COUNT
from
    TMP
where
    D between '2023-08-01' and '2023-08-31'
group by 1
order by FIRST_LOGIN desc