with FIRST_LOGINS as
(
    select
        member_code
        , min (strftime('%Y-%m-%d', login_datetime)) first_login
    from 
        ACCESS_LOG
    where
       strftime('%Y-%m-%d', login_datetime) between '2023-08-01' and '2023-08-31'
    group by member_code
     
)
    select
        first_login 'FIRST_LOGIN'
        ,COUNT(*) 'MEMBER_CNT'
    from
        first_logins
    group by 
        first_login
    order by
    1 desc