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