with cte as(select 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