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