with tmp as(
select min(LOGIN_DATETIME) 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