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