SELECT *
  FROM(
    SELECT DISTINCT MIN(LOGIN_DATETIME) OVER (PARTITION BY MEMBER_CODE) 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