SELECT 
  substr(B.LOGIN_DATETIME,1,10) as FIRST_LOGIN,
  count(A.test) as MEMBER_CNT
FROM 
(SELECT 
  MEMBER_CODE,
  min(LOGIN_DATETIME) as test
FROM ACCESS_LOG
WHERE LOGIN_DATETIME between '2023-08-01' and '2023-09-01'
Group by MEMBER_CODE) as A
inner join ACCESS_LOG as B
ON A.test = B.LOGIN_DATETIME
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN desc