select
    substring(FORMAT(LOGIN_DATETIME,'yyyy-mm-dd'),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;