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