SELECT
    fl as FIRST_LOGIN
    ,count(*) as MEMBER_CNT
FROM
(
    SELECT
        *
        ,strftime('%Y-%m-%d',min(login_datetime) over(partition by MEMBER_CODE)) as fl
    FROM
        ACCESS_LOG
    WHERE
            LOGIN_DATETIME >= '2023-08-01'
        and LOGIN_DATETIME < '2023-09-01'
)T
group by fl
order by fl desc