WITH TARGET AS (
	SELECT
		MEMBER_CODE,
		SUBSTR(MIN(LOGIN_DATETIME), 1, 10) AS MIN_DATE
	FROM
		ACCESS_LOG
	GROUP BY
		MEMBER_CODE
)

SELECT
	MIN_DATE AS FIRST_LOGIN,
	COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
	TARGET
WHERE 
	MIN_DATE >= '2023-08-01'
AND MIN_DATE < '2023-09-01'
GROUP BY
    FIRST_LOGIN
ORDER BY
	FIRST_LOGIN DESC
;