with WK_LOGIN_TABLE as(
select 
MEMBER_CODE
,DATE(LOGIN_DATETIME) as FIRST_LOGIN
from ACCESS_LOG
where not exists (
            select MEMBER_CODE
            from (
            select
                MEMBER_CODE
                ,DATE(LOGIN_DATETIME) as FIRST_LOGIN
            from ACCESS_LOG
            where FIRST_LOGIN <'2023-08-01')wk
            where ACCESS_LOG.MEMBER_CODE = wk.MEMBER_CODE)
        and LOGIN_DATETIME between '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
group by MEMBER_CODE
)
select
    FIRST_LOGIN
    ,count(FIRST_LOGIN)
from WK_LOGIN_TABLE
group by FIRST_LOGIN
order by  FIRST_LOGIN desc;