with login_in_august as (
    select
        MEMBER_CODE           as MEMBER_CODE
      , 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
), first_login as (
    select
        MEMBER_CODE          as MEMBER_CODE
      , min(LOGIN_DATETIME)  as LOGIN_DATETIME
    from
        login_in_august
    group by
       MEMBER_CODE
)
select
    LOGIN_DATETIME as FIRST_LOGIN
  , count(LOGIN_DATETIME)
from
    first_login
order by
    LOGIN_DATETIME desc
;