with tmp as (
select
    member_code
    ,min(date(login_datetime)) min_date
from
    access_log
where
    date(login_datetime) between '2023-08-01' and '2023-08-31'
group by
    member_code
)
select
    min_date FIRST_LOGIN
    ,count(member_code) MEMBER_CNT
from
    tmp
group by
    min_date
order by
    min_date desc
;