SELECT
 date(A.LOGIN_DATETIME) AS FIRST_LOGIN
,COUNT(*) AS MEMBER_CNT
FROM
(
 SELECT 
  MEMBER_CODE,
  MIN(LOGIN_DATETIME) AS LOGIN_DATETIME
 FROM
  ACCESS_LOG
WHERE
    LOGIN_DATETIME >= datetime('2023-08-01 00:00:00')
AND LOGIN_DATETIME <= datetime('2023-08-31 23:59:59')
 GROUP BY 
  MEMBER_CODE
) AS A
GROUP BY
 date(A.LOGIN_DATETIME)
ORDER BY
 date(A.LOGIN_DATETIME) DESC