SELECT
CAST(LOGIN_DATETIME AS DATE) AS FIRST_LOGIN,
COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT

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;