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)
    select date as "FIRST_LOGIN", count(member_code) as "MEMBER_CNT"
    from cte
    where ranking == 1 and STRFTIME("%m", date) == "08"
    group by 1
    order by 1 desc