select
    sub.FIRST_LOGIN_DATE as FIRST_LOGIN
    ,count(sub.member_code) as MEMBER_CNT
from
    -- 会員ごとに初めてログインした日を取得する
    (
        select
            member_code
            ,min(date(login_datetime)) as FIRST_LOGIN_DATE
        from
            access_log
        group by
            member_code
    ) as sub
group by
    FIRST_LOGIN
    having
        sub.FIRST_LOGIN_DATE between '2023-08-01' and '2023-08-31'
order by
    FIRST_LOGIN desc
;