with TMP1 as (
select
    MEMBER_CODE
    ,min(LOGIN_DATETIME) as DT
from ACCESS_LOG
group by 1
)

select
    date(DT) as FIRST_LOGIN
    ,count(*) as MEMBER_CNT
from
    TMP1
where
    DT between '2023-08-01' and '2023-08-31'
group by 1 order by 1 desc