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