with sub as (
    select
        MIN(DATE(LOGIN_DATETIME)) as FIRST_LOGIN
        ,MEMBER_CODE
    from ACCESS_LOG
    where LOGIN_DATETIME between'2023-08-01 00:00:00' and '2023-08-31 23:59:59'
    group by MEMBER_CODE
    order by FIRST_LOGIN desc
    )
    
select
    FIRST_LOGIN
    ,count(*) as MEMBER_CNT
from sub
group by FIRST_LOGIN
order by FIRST_LOGIN desc