with tmp as(
select min(substr(LOGIN_DATETIME,1,10)) over(partition by MEMBER_CODE) as MIN_LOGIN_DATETIME,
LOGIN_DATETIME
  from ACCESS_LOG)
select MIN_LOGIN_DATETIME as FIRST_LOGIN,
count(*) 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