with tmp_t as (select ACCESS_ID,MEMBER_CODE,LOGIN_DATETIME,
row_number() over(partition by date(LOGIN_DATETIME) order by ACCESS_ID) row_num 
from ACCESS_LOG)

select date(LOGIN_DATETIME) as FIRST_LOGIN, count(*) as MEMBER_CNT
from tmp_t
where row_num = 1
and LOGIN_DATETIME between '2023-08-01' and '2023-08-31'
order by LOGIN_DATETIME desc;