with tmp as(
select 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(*) as MEMBER_CNT
  from tmp
 where MIN_LOGIN_DATETIME between '2023-08-01' and '2023-08-31'
group by MIN_LOGIN_DATETIME
order by FIRST_LOGIN desc