WITH TARGET AS (
	SELECT
		MEMBER_CODE,
		SUBSTR(MIN(LOGIN_DATETIME), 1, 10) AS 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
)

SELECT
	MIN_DATE AS FIRST_LOGIN,
	COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
	TARGET
GROUP BY
    FIRST_LOGIN
ORDER BY
	FIRST_LOGIN DESC
;