with FIRST_LOGIN_BY_USER as (
    select 
        MEMBER_CODE
        , min(date(LOGIN_DATETIME)) as FIRST_LOGIN
    from 
        ACCESS_LOG
    where 
        date(LOGIN_DATETIME) between '2023-08-01' and '2023-08-31'
    group by 
        MEMBER_CODE
)

select 
    FIRST_LOGIN
    , count(*) as MEMBER_CNT
from 
    FIRST_LOGIN_BY_USER
group by 
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;