select
   FIRST_LOGIN
 , count(MEMBER_CODE)
from (
 select
    min(date(LOGIN_DATETIME)) as FIRST_LOGIN
  , MEMBER_CODE
 from
   ACCESS_LOG
 group by
   MEMBER_CODE
 order by
   min(LOGIN_DATETIME) desc)
 where
   FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by
  FIRST_LOGIN
order by
  FIRST_LOGIN desc;