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