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