SELECT
	TMP.MIN_DATE  FIRST_LOGIN,
	COUNT(*) MEMBER_CNT 
FROM
	(
		SELECT
			MEMBER_CODE,
			date(MIN(LOGIN_DATETIME)) MIN_DATE
		FROM
			ACCESS_LOG
		WHERE
			LOGIN_DATETIME >= ('2023-08-01 00:00:00') AND
			LOGIN_DATETIME <  ('2023-09-01 00:00:00') 
		GROUP BY
			MEMBER_CODE
	)TMP
GROUP BY
	TMP.MIN_DATE
ORDER BY
	TMP.MIN_DATE DESC