WITH basedata AS (
	SELECT
		MEMBER_CODE
		,MIN(LOGIN_DATETIME) AS mindate
	FROM ACCESS_LOG
	WHERE LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'
	GROUP BY MEMBER_CODE
)
SELECT
	DATE(mindate) AS FIRST_LOGIN
	,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM basedata
GROUP BY 1
ORDER BY 1 DESC