WITH tmp as
        (SELECT
        date(min(LOGIN_DATETIME)) AS FIRST_LOGIN,
        MEMBER_CODE
        FROM ACCESS_LOG a
        where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
        and not exists
        (select 1 from ACCESS_LOG b where a.member_code=b.member_code and b.LOGIN_DATETIME<'2023-08-01')
        group by MEMBER_CODE)
        
        
      SELECT 
        FIRST_LOGIN,
        count(*) as MEMBER_CNT
        from tmp
        group by FIRST_LOGIN
        order by FIRST_LOGIN desc;