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) between date('2023-08-01') and date('2023-08-31')
)
select
    login_min AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS MEMBER_CNT
from
    temp
group by
    login_min
order by
    FIRST_LOGIN DESC
;