with temp as (
    select distinct
        MEMBER_CODE
        ,MIN(date(LOGIN_DATETIME)) OVER(partition by MEMBER_CODE) AS login_min
    from
        ACCESS_LOG
    where
        date(LOGIN_DATETIME) >= date('2023-08-01')
)

select
    login_min AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS MEMBER_CNT
from
    temp
group by
    login_min
order by
    FIRST_LOGIN DESC
;