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