SELECT LOGIN_DATETIME AS FIRST_LOGIN,
       COUNT(*) AS MEMBER_CNT
  FROM  (SELECT MEMBER_CODE,
                DATE(LOGIN_DATETIME) AS LOGIN_DATETIME,
                ROW_NUMBER() OVER(PARTITION BY MEMBER_CODE ORDER BY LOGIN_DATETIME ASC) AS NUM
           FROM ACCESS_LOG
        )
 WHERE NUM = 1
   AND '2023-08-01' <= LOGIN_DATETIME 
   AND LOGIN_DATETIME <= '2023-08-31'
 GROUP BY FIRST_LOGIN
 ORDER BY FIRST_LOGIN DESC