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