SELECT DATE(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN, COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM (
  SELECT MIN(LOGIN_DATETIME) AS LOGIN_DATETIME, MEMBER_CODE
  FROM ACCESS_LOG
  WHERE strftime('%Y-%m', LOGIN_DATETIME) = '2023-08'
  GROUP BY MEMBER_CODE
) subquery
GROUP BY DATE(subquery.LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC;