WITH Pre AS(
SELECT
    ACCESS_ID,
    MEMBER_CODE,
    strftime('%Y-%m', LOGIN_DATETIME) AS strftime,
    strftime('%Y-%m-%d', LOGIN_DATETIME) AS strftime_d,
    LOGIN_DATETIME
FROM
    ACCESS_LOG
WHERE
    strftime = '2023-08'
GROUP BY
    MEMBER_CODE
)
SELECT
    strftime_d AS FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    Pre
GROUP BY
    strftime_d
ORDER BY
	strftime_d DESC