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