with group_by_date_membercode as ( 
    SELECT
        MEMBER_CODE
        , substr(LOGIN_DATETIME, 1, 10) as LOGIN_DATETIME 
    FROM
        ACCESS_LOG 
    WHERE
        LOGIN_DATETIME >= '2023-08-01' 
        and LOGIN_DATETIME < '2023-09-01' 
    GROUP BY
        MEMBER_CODE
        , substr(LOGIN_DATETIME, 1, 10)
) 
, distinct_group_by_membercode as ( 
    select
        * 
    from
        group_by_date_membercode 
    group by
        MEMBER_CODE
) 
select
    LOGIN_DATETIME as 'FIRST_LOGIN'
    , count(*) as 'MEMBER_CNT' 
from
    distinct_group_by_membercode
group by
    LOGIN_DATETIME 
order by
    FIRST_LOGIN desc