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