with tmp as(
select LOGIN_DATETIME,MEMBER_CODE,
min(substr(LOGIN_DATETIME,1,10)) over(partition by MEMBER_CODE) as MIN_LOGIN_DATETIME
  from ACCESS_LOG)
select MIN_LOGIN_DATETIME as FIRST_LOGIN,
count(distinct MEMBER_CODE) as MEMBER_CNT
  from tmp
 where substr(LOGIN_DATETIME,1,10) = MIN_LOGIN_DATETIME
   and MIN_LOGIN_DATETIME between '2023-08-01' and '2023-08-31'
group by MIN_LOGIN_DATETIME
order by FIRST_LOGIN desc