SELECT
    LOGIN_DATETIME AS FIRST_LOGIN,
    COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME LIKE '2023-08%'
GROUP BY LOGIN_DATETIME
ORDER BY FIRST_LOGIN DESC;