SELECT MIN(LOGIN_DATETIME) AS FIRST_LOGIN, COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM ACCESS_LOG
WHERE strftime('%Y-%m', LOGIN_DATETIME) = '2023-08'
GROUP BY strftime('%Y-%m-%d', LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC;