with first_login as (
    select
        MEMBER_CODE               as MEMBER_CODE
      , min(date(LOGIN_DATETIME)) as LOGIN_DATETIME
    from
        ACCESS_LOG
    where
       '2023-08-01' <= LOGIN_DATETIME and LOGIN_DATETIME < '2023-09-01'
    group by
       MEMBER_CODE

)
select
    LOGIN_DATETIME as FIRST_LOGIN
  , count(LOGIN_DATETIME)
from
    first_login
order by
    LOGIN_DATETIME desc
;