select
date(LOGIN_DATETIME) as  FIRST_LOGIN,
count(MEMBER_CODE) as MEMBER_CNT
from ACCESS_LOG
where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59' 
and MEMBER_CODE NOT IN (select MEMBER_CODE from ACCESS_LOG where LOGIN_DATETIME < '2023-08-01 00:00:00')
group by FIRST_LOGIN
order by FIRST_LOGIN desc
;