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
    WHERE strftime('%Y-%m', LOGIN_DATETIME) = '2023-08'
    GROUP BY MEMBER_CODE
)
GROUP BY strftime('%Y-%m-%d', access_date)
ORDER BY FIRST_LOGIN DESC;