SELECT
    fl as FIRST_LOGIN,
    count(*) as MEMBER_CNT
FROM
(
    SELECT
        distinct MEMBER_CODE,fl
    FROM
    (
        SELECT
            *
            ,strftime('%Y-%m-%d',min(login_datetime) over(partition by MEMBER_CODE)) as fl
        FROM
            ACCESS_LOG
    )T
)TT
group by fl
having fl between '2023-08-01' and '2023-08-31'
order by fl desc