with a as
(select
 MEMBER_CODE as member
 ,min(date(LOGIN_DATETIME)) as login_date
from ACCESS_LOG
group by member
)
select
login_date as FIRST_LOGIN
,count(*) as MEMBER_CNT
from a
where date(FIRST_LOGIN) between  date('2023-08-01') and date('2023-08-31')
group by login_date
order by date(FIRST_LOGIN) desc;