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