WITH table_tmp AS(
select 
  *
 from (
   select
    *,
    row_number() over (PARTITION BY MEMBER_CODE ORDER BY  LOGIN_DATETIME ASC) AS number
    FROM ACCESS_LOG
  )
  WHERE number = 1 AND LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-09-01'
)

SELECT
	date(LOGIN_DATETIME) AS FIRST_LOGIN,
	COUNT(MEMBER_CODE)
FROM table_tmp
GROUP BY date(LOGIN_DATETIME)
ORDER BY LOGIN_DATETIME DESC
;