select
    sub.FIRST_LOGIN_DATETIME as FIRST_LOGIN
    ,count(mem_code) as MEMBER_CNT
from
    (
        select
            member_code as mem_code
            ,min(date(login_datetime)) as FIRST_LOGIN_DATETIME
        from
            access_log
        -- where
        --     login_datetime between '2023-08-01' and '2023-09-01'
        group by member_code
            having login_datetime between '2023-08-01' and '2023-09-01'
    ) as sub
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;