SELECT FIRST_LOGIN
      ,COUNT(*)
  FROM(
    SELECT DISTINCT MIN(SUBSTR(LOGIN_DATETIME, 0, 11)) OVER (PARTITION BY MEMBER_CODE) AS FIRST_LOGIN
          ,MEMBER_CODE
      FROM ACCESS_LOG
  )
 WHERE FIRST_LOGIN LIKE '2023-08%'
 GROUP BY FIRST_LOGIN
 ORDER BY FIRST_LOGIN DESC