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