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