with login_in_august as (
    select
        MEMBER_CODE
      , date(LOGIN_DATETIME)  as LOGIN_DATETIME
    from
        ACCESS_LOG
    group by
        MEMBER_CODE
), first_login as (
    select
        MEMBER_CODE          as MEMBER_CODE
      , min(LOGIN_DATETIME)  as FIRST_LOGIN
    from
        login_in_august
    where
       '2023-08-01' <= LOGIN_DATETIME and LOGIN_DATETIME < '2023-09-01'
    group by
        MEMBER_CODE
)
select
    FIRST_LOGIN        as FIRST_LOGIN
  , count(FIRST_LOGIN) as MEMBER_CNT
from
    first_login
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;