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
)T
group by fl
having fl between '2023-08-01' and '2023-08-31'
order by fl desc