with cte as(select distinct member_code, strftime("%Y-%m-%d", login_datetime) as date,rank() over(
        partition by member_code
        order by login_datetime
    ) as ranking
    from access_log
    where STRFTIME("%m", login_datetime) == "08")
    select date as "FIRST_LOGIN", count(member_code) as "MEMBER_CNT"
    from cte
    where ranking == 1
    group by 1
    order by 1 desc