select
    substring(LOGIN_DATETIME,1,10) AS FIRST_LOGIN,
    COUNT(DISTINCT LOGIN_DATETIME) AS MEMBER_COUNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME  BETWEEN '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC;