with to_date as (
    select
        MEMBER_CODE
        , substr(LOGIN_DATETIME, 1, 10) as 'LOGIN_DATE'
    from
        ACCESS_LOG
), first_login_date as (
    select
    	MEMBER_CODE
    	, FIRST_VALUE(LOGIN_DATE) over (partition by MEMBER_CODE order by LOGIN_DATE asc) as 'FIRST_LOGIN'
    from
    	to_date
    group by
    	MEMBER_CODE
)
select 
    FIRST_LOGIN as 'FIRST_LOGIN'
    , count(*) as 'MEMBER_CNT'
from
    first_login_date
where
    FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;