select
  substr(LOGIN_DATETIME, 0, 11) as FIRST_LOGIN,
  count(*) as MEMBER_CNT
  from
    (
      select *
        from ACCESS_LOG
       group by MEMBER_CODE
       order by
   LOGIN_DATETIME asc
    )
 where date(LOGIN_DATETIME) >= date("2023-08-01")
   and date(LOGIN_DATETIME) <= date("2023-08-31")
 group by substr(LOGIN_DATETIME, 0, 11)
 order by
substr(LOGIN_DATETIME, 0, 11) desc
      ;