select
  FIRST_LOGIN
 ,count(*) as MEMBER_CNT
from
(
select
  min(substr(LOGIN_DATETIME, 1, 10)) as FIRST_LOGIN
from
    ACCESS_LOG as main
where
  LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 99:99:99'
group by
  MEMBER_CODE
)
group by
  FIRST_LOGIN
order by
FIRST_LOGIN desc;