SELECT DATE(LOGIN_DATETIME) AS FIRST_LOGIN, COUNT(LOGIN_DATETIME) AS MEMBER_CNT
FROM ACCESS_LOG
WHERE FIRST_LOGIN BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC;