with
    kizon as (
        select
            distinct member_code as member_code
        from
            access_log
        where
            login_datetime < '2023-08-01 00:00:00'
    )
    ,aug as (
        select
            member_code
            ,min(date(login_datetime)) as first_login
        from
            access_log
        where
            login_datetime >= '2023-08-01 00:00:00'
            and login_datetime < '2023-09-01 00:00:00'
            and member_code not in (select member_code from kizon)
        group by
            1
    )
    
select
    first_login as FIRST_LOGIN
    ,count(member_code) as MEMBER_CNT
from
    aug
group by
    1
order by
    1 desc