SELECT
	FIRST_LOGIN_DATE AS FIRST_LOGIN
	,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
	(
	SELECT
		MEMBER_CODE,
		MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN_DATE
	FROM
		ACCESS_LOG
	GROUP BY
		MEMBER_CODE
	HAVING
		DATE(LOGIN_DATETIME) BETWEEN '2023-08-01' AND '2023-08-31'
	) AS subTable
GROUP BY
	FIRST_LOGIN_DATE
ORDER BY
	FIRST_LOGIN_DATE DESC