SELECT strftime('%Y-%m-%d', MIN(access_date)) AS FIRST_LOGIN,
       COUNT(*) AS MEMBER_CNT
FROM (
    SELECT MEMBER_CODE, MIN(LOGIN_DATETIME) AS access_date
    FROM ACCESS_LOG
    GROUP BY MEMBER_CODE
    ORDER BY access_date DESC
)
WHERE strftime('%Y-%m', access_date) = '2023-08'
GROUP BY strftime('%Y-%m-%d', access_date)
ORDER BY FIRST_LOGIN DESC;